LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automating Excel mvpejp Excel Discussion (Misc queries) 0 November 22nd 05 07:33 PM
automating jmp thru excel [email protected] Excel Programming 3 October 4th 05 07:53 PM
Automating Excel John Excel Programming 1 January 26th 05 06:44 PM
Automating Excel (XL2002) Randy[_12_] Excel Programming 1 November 4th 03 02:19 PM
Automating Excel from VB .NET Howard Kaikow Excel Programming 12 August 31st 03 02:56 AM


All times are GMT +1. The time now is 11:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"