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



  #3   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default 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



.

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
ms-excel guidence notes, complete formulas in excel, How to runmacros in Ms excel [email protected] Excel Discussion (Misc queries) 0 June 14th 08 03:19 PM
Data Import to Excel Issue with Excel 2007 and Excel 2003 on same Melsh Excel Discussion (Misc queries) 0 August 1st 07 09:32 PM
Excel Not Talking To Outlook [Email Settings] wkwork Excel Discussion (Misc queries) 1 September 1st 05 07:21 PM
Excel 2003 crashes loading excel files created Excel 2000 Jeff Lewin Australia Excel Discussion (Misc queries) 0 June 27th 05 04:20 AM
Excel and Access talking GJR3599 Excel Discussion (Misc queries) 0 March 29th 05 04:59 PM


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

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"