View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Automation and Add-Ins

When you open Excel via automation no auto-loading files are opened,
including add-ins. You could enhance your script to open the add-in though.
You can use Application.LibraryPath to find the path.

--
Jim Rech
Excel MVP