Need help with ADXRemoteObject - in Excel

Add-in Express™ Support Service
That's what is more important than anything else

Need help with ADXRemoteObject - in Excel
 
Ben Tsui




Posts: 2
 Joined: 2006-08-01
Hi,

I developed a COM-AddIn for Excel with AddInExpress .NET 2.7

I referenced the COM-AddIn using:

Set remObj=Application.COMAddIns.Item ("HelloWorldAddInShim.Proxy").Object

I'm getting an error when I try to call a public Function that resides in the addin module using:

remObj.CallMethod("HelloWorld")

My reference to ADXRemoteObject didn't seem to have any methods in it. I was wondering where in my addin project I should put my public methods/functions so that I can call them from VBA?


Any help would be most appreciated.

Thanks.
Ben.
Posted 01 Aug, 2006 11:37:12 Top
Sergey Grischenko


Add-in Express team


Posts: 7235
 Joined: 2004-07-05
Hi Ben.

Please look at the following topic:
http://www.add-in-express.com/forum/read.php?FID=5&TID=1206&MID=5621&phrase_id=231579#message5621

I was wondering where in my addin project I should put my public methods/functions so that I can call them from VBA?

You should add your methods/functions to the AddinModule class.
Posted 02 Aug, 2006 17:05:25 Top