View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default Call a add_in function in excel vba?

Two ways

Set a reference to the addin (ToolsReferebces)

or use application run

Application.Run "addin_name.xla!macro_name"

--
HTH

Bob Phillips

"libing" wrote in message
...

the add_in is installed, and I want to call the functions from the
add_in, seems doesn't work,how?


--
libing
------------------------------------------------------------------------
libing's Profile: http://www.msusenet.com/member.php?userid=1773
View this thread: http://www.msusenet.com/t-1870496572