Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Scripting (vbscript) doesn't load Excel add-ins
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Scripting (vbscript) doesn't load Excel add-ins
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" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SCripting Border in Excel | Excel Programming | |||
VBA scripting in Excel | Excel Programming | |||
AVAYA CMS Scripting through Excel VBA | Excel Programming | |||
Scripting Excel - EXCEL.EXE refuses to leave task manager after .Quit and =Nothing? | Excel Programming | |||
is excel by itself enough to do scripting? | Excel Programming |