loading com addins with automation

[Guest]

Can anybody tell me how to load COM addins in Excel using automation scripts?
Several posts show how to load xla addins, but this solution does not work
with dll com addins.

set xlApp = CreateObject("Excel.Application")
xlApp.Application.visible = true
xlApp.workbooks.open "somefile.xls"
.... Code to load MyComAddin.dll

 

[DM Unseen]

COM addins are loaded by the application through registry setttings.
Just register your COM addin it will then be picked up by the app.BTW
registering com addins is not that trivial but see:

http://groups.google.com/[email protected]&rnum=6


DM Unseen

 

[Tushar Mehta]

Check Application object's COMAddIns property, and the COMAddIn
object's Connect property. Don't know how far that will get you but...

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions