Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,120
Default 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



  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,758
Default 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


  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possible to call an excel function indirectly? Alban??? Excel Discussion (Misc queries) 4 February 27th 09 04:59 PM
CALL .NET FUNCTION FROM EXCEL VSTO Beginner Excel Worksheet Functions 0 February 27th 08 06:57 AM
Add_In VS Reference Ajit Excel Programming 1 November 17th 04 06:57 PM
how to call Access's function in different module in Excel VBA miao jie Excel Programming 0 July 25th 04 04:03 AM
Write a function call into an Excel cell from VBA Conceptor Excel Programming 2 September 10th 03 05:41 PM


All times are GMT +1. The time now is 11:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"