Call a add_in function in excel vba?
 

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

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

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

Call a add_in function in excel vba?
 

I set a reference, still doesn't work,is it a mavro

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

Call a add_in function in excel vba?
 

Is what a macro?

--
HTH

Bob Phillips

"libing" wrote in message
...

I set a reference, still doesn't work,is it a mavro?


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

Call a add_in function in excel vba?
 

Do you mean you want to user your userdefined function in a cell in the other
workbook?

If yes, then:

=myfunction(a1)

should work (myfunction is a UDF in the addin that's loaded).

libing wrote:

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

--

Dave Peterson

Call a add_in function in excel vba?
 

i want to use the function from the addin in my vba code,why ru
"addin_name.xla!macro_name:?bob, may I have ur msn or skype, i reall
want to make it clear

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

Call a add_in function in excel vba?
 

what is your email?
my question is i want to use this function in my vba code, the addin i
in 'C:\Program files\HoadleyOptions\HoadleyOptions.xla'!, and th
function is named ...(arguments), what to call this function, thanks
lo

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