Excel VBA talking to Excel COM Add-in  
Author Message
AngelaWilkinson





PostPosted: Thu Oct 23 20:49:29 CDT 2003 Top

Excel Programming >> 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

Excel8  
 
 
Tom





PostPosted: Thu Oct 23 20:49:29 CDT 2003 Top

Excel Programming >> 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.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




> 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


 
 
anonymous





PostPosted: Sun Oct 26 16:52:29 CST 2003 Top

Excel Programming >> 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
>
>

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
>
>
>.
>