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. |
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. |
All times are GMT +1. The time now is 11:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com