ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel VBA talking to Excel COM Add-in (https://www.excelbanter.com/excel-programming/280445-excel-vba-talking-excel-com-add.html)

Michael Green

Excel VBA talking to Excel COM Add-in
 
Hi,
I have need to have Excel worksheet VBA access data and
call functions in an Excel COM-Addin.

How do I do this ?

Regards
Michael

Tom Ogilvy

Excel VBA talking to Excel COM Add-in
 
Perhaps these contain the information you need:

Note that xl2000 does not support direct use. XL2002 introduced the
Automation Add-in.

XL 2000
http://support.microsoft.com/default...&Product=xlw2K
HOWTO: Use a COM Add-In Function as an Excel Worksheet Function

XL 2002/2003
http://support.microsoft.com/default...&Product=xl200
2
HOWTO: Create a Visual Basic Automation Add-in for Excel Worksheet Functions

--
Regards,
Tom Ogilvy


Michael Green wrote in message
...
Hi,
I have need to have Excel worksheet VBA access data and
call functions in an Excel COM-Addin.

How do I do this ?

Regards
Michael




No Name

Excel VBA talking to Excel COM Add-in
 
Many thanks for that !


-----Original Message-----
Perhaps these contain the information you need:

Note that xl2000 does not support direct use. XL2002

introduced the
Automation Add-in.

XL 2000
http://support.microsoft.com/default.aspx?scid=kb;en-

us;256624&Product=xlw2K
HOWTO: Use a COM Add-In Function as an Excel Worksheet

Function

XL 2002/2003
http://support.microsoft.com/default.aspx?scid=kb;en-

us;285337&Product=xl200
2
HOWTO: Create a Visual Basic Automation Add-in for Excel

Worksheet Functions

--
Regards,
Tom Ogilvy


Michael Green wrote in

message
...
Hi,
I have need to have Excel worksheet VBA access data and
call functions in an Excel COM-Addin.

How do I do this ?

Regards
Michael



.



All times are GMT +1. The time now is 01:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com