sw21
02-12-2010, 02:41 PM
Hi,
I have a few add-ins that are launched when Excel start. If I go in the VBA editor, I see all the addins in the VBAProject panel.
But here is the problem:
Im trying to launch Excel with a VBScript. The addins are ticked in Tools -> Add-Ins but in VBA I see nothing and the addins are not launch at the start of excel (I can see it since they are big it takes time to launch them!).
here is the sort of VBScript Im using:
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
Very simple, but it doesnt do the same thing as when I launch Excel by myself.
Does anyone has an idea ?
Swan
I have a few add-ins that are launched when Excel start. If I go in the VBA editor, I see all the addins in the VBAProject panel.
But here is the problem:
Im trying to launch Excel with a VBScript. The addins are ticked in Tools -> Add-Ins but in VBA I see nothing and the addins are not launch at the start of excel (I can see it since they are big it takes time to launch them!).
here is the sort of VBScript Im using:
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
Very simple, but it doesnt do the same thing as when I launch Excel by myself.
Does anyone has an idea ?
Swan