View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Aaron Fude Aaron Fude is offline
external usenet poster
 
Posts: 9
Default Script to start Excel and load the add-ins

Hi, I have the following script to start Excel if it is not started and to
use an existing instance if it is:

Dim XL
Dim agrs
on error resume next
set XL = GetObject(,"Excel.Application")
If XL is Nothing Then Set XL = CreateObject("Excel.Application")
Set args = WScript.Arguments
XL.Workbooks.Open args(0)
XL.Visible = True

The problem is that if Excel is not started and this starts a new instance,
my add-ins (that are checked) do not load.

How to solve this?

Many thanks in advance,

Aaron Fude