Posted to microsoft.public.excel.programming

Matthew Wieder[_3_] Matthew Wieder[_3_] is offline

external usenet poster

Posts: 30

REPOST: Calling Excel Automation Add-In in VBA

We have an Automation Add-In that we developed in C# (2.0) which we are
calling from the worksheet in Excel (2003). We want to be able to call
functions in that AddIn from VBA code in teh workbook as well. If it was a
COM Add-IN, we could call
Application.COMAddIns.Item("TestAutomationAddIn.Fu nctions").Object to get a
handle to the AddIn and make calls on it, but the Application.AddIns
Collection (where Automation AddIns are accessed) does not expose the Object
property. How can I get a handle to my Automation AddIn?
thanks!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Calling Excel Automation Add-In in VBA	Matthew Wieder[_2_]	Excel Programming	0	June 13th 06 07:59 PM
Calling Excel Automation Add-In in VBA	Matthew Wieder	Excel Programming	0	June 13th 06 07:14 PM
Repost Excel Server Problem	[email protected]	Excel Programming	0	August 6th 05 08:55 AM
RePost - Calling a Macro from a key	RWN	Excel Programming	8	March 19th 05 12:50 AM
repost: Print *.tif file from excel vba	marcus	Excel Programming	1	May 27th 04 12:05 PM

All times are GMT +1. The time now is 06:23 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us