View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mario mario is offline
external usenet poster
 
Posts: 26
Default loading com addins with automation

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