Excel VBA talking to Excel COM Add-in

[Michael Green]

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]

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

 

[Guest]

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





.