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

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

Post by Lee » Tue, 24 Feb 2009 23:10:01


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.
 
 
 

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

Post by Chip Pears » Tue, 24 Feb 2009 23:23:21


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)

On Mon, 23 Feb 2009 09:10:01 -0500, "Lee" < XXXX@XXXXX.COM >