Unable to find Com Addin reference in Excel

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

Unable to find Com Addin reference in Excel
Excel Com addin problem 
Lee Turley




Posts: 2
 Joined: 2008-09-11
Hiya,

I have created an Excel Com Addin and I was able to use it when I was developing it by registering it in Visual Studio.

However, after I have built it and installed it, I can not see a reference to it when I try to add it in the VBA editor, Tools, References and I cannot find it in the list of available references.

Am I doing something wrong?

Thanks for any help.

Regards
Lee
Posted 11 Sep, 2008 13:35:45 Top
Eugene Astafiev


Guest


Hello Lee,

Did you check up the COM Add-ins dialog? You will not see your add-in listed in the VBA project references dialog.
Posted 11 Sep, 2008 15:05:24 Top
Lee Turley




Posts: 2
 Joined: 2008-09-11
Thank you Eugene,

Yes it is in the Com Add-ins dialog. I was looking in the wrong place!

Could someone tell me how I can use the Add-in in VBA. When I declare it in VBA and try to use it, I get a "User defined type not defined error".

Any help is very much appreciated.

Regards
Lee
Posted 12 Sep, 2008 06:00:12 Top
Eugene Astafiev


Guest


Lee,

You can use the COMAddIns property of the Application object. For example: 

Application.COMAddIns
Posted 12 Sep, 2008 07:48:23 Top