Excel Scripting (vbscript) doesn't load Excel add-ins

[Lee]

I have a vbscript that opens excel and performs some analysis.
I have an add-in that needs to be loaded when I run the script, but it does
not.

If I just open excel, the add-in loads fine, but when the script opens
excel, the add-in does not load.

is this by design, or is there a way around this?

Thanks in advance.

 

[Chip Pearson]

When Excel is opened via automation, start up files and add-ins are
not loaded. This is by design to make the application start as quickly
as possible. If you need to load an add-in, you must do so with code:

XLApp.AddIns("Add In Name").Installed = True

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)