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

--
Mario Delamboy

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/groups?q=Re...gle.com&rnum=6


DM Unseen

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

In article ,
says...
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