Automating Excel with add-in
 

Hi all!

I have the following problem with automating Excel 2003.

I automate it from WSH. The idea is to open a workbook (wkbk.xls),
wait for a definite amount of time (30 sec.),
then save it and close Excel.

Using standard procedure (in a VBS script):

wkbk = "...path...\wkbk.xls"
set oExcel = CreateObject("Excel.Application")
oExcel.Workbooks.Open wkbk
WScript.Sleep 30000
oExcel.ActiveWorkBook.Save
oExcel.ActiveWorkBook.Close
oExcel.Quit

everything works as expected.

The problem is that Excel is setup on my computer with an add-in
that fetches some data from the internet while the wkbk.xls is open.

If I double-click wkbk.xls this operation is performed OK,
while if wkbk.xls is open by the above script, it is not:
if (during the 30 sec. period) I check Tools - Add-Ins
the add-in is not even listed among the Add-ins available.

How can I force the Excel aplication object to be "started"
with the required add-in?

TIA,
Nick

Automating Excel with add-in
 

Have you tried adding the add-in into the workbook.open event ?

AddIns("MyAddInName").Installed = True


--
Cheers
Nigel



"Nick S." wrote in message
om...
Hi all!

I have the following problem with automating Excel 2003.

I automate it from WSH. The idea is to open a workbook (wkbk.xls),
wait for a definite amount of time (30 sec.),
then save it and close Excel.

Using standard procedure (in a VBS script):

wkbk = "...path...\wkbk.xls"
set oExcel = CreateObject("Excel.Application")
oExcel.Workbooks.Open wkbk
WScript.Sleep 30000
oExcel.ActiveWorkBook.Save
oExcel.ActiveWorkBook.Close
oExcel.Quit

everything works as expected.

The problem is that Excel is setup on my computer with an add-in
that fetches some data from the internet while the wkbk.xls is open.

If I double-click wkbk.xls this operation is performed OK,
while if wkbk.xls is open by the above script, it is not:
if (during the 30 sec. period) I check Tools - Add-Ins
the add-in is not even listed among the Add-ins available.

How can I force the Excel aplication object to be "started"
with the required add-in?

TIA,
Nick

Automating Excel with add-in
 

Thank you very much for the hint, Nigel.

In the meantime I bumped into another problem. I found out that
installation of an add-in is bound to the user logged-in: it is
registered in HKEY_CURRENT_USER not in HKEY_LOCAL_MACHINE.

As I intended to run the script as a scheduled task when nobody is
logged in on the computer I have great doubts whether it could work...

If you happen to have an idea how to do it anyway, please, let me know.

Regards,
Nick