Open excel using Scheduled Task

[tuktuk]

Hey there,

I have an excel file that i trigger to open durign the middle of the night using the Task Scheduler.

Code is triggered using the On_Open() cmd. Part of the code is to extract / pull data from Essbase.

The issues is that I can only have one connection to essbase....so if i already have an instance of Excel open adn then the task sched is triggered it opens another instance of excel (rather than using the active / currently open instance), thus resulting is the dataset not pulling properly.

I guess my option would be to run code at night to close all instances of excel if any are active or tell the task sched to open the requested file to the active instance.

any ideas?

tuktuk

 

[Jonmo1]

under normal every day circumstances..

When you have one book open, and you double click on the icon for another book, does it open in the same instance, or new instance?

If this opens in a new instance, you can change settings for the filetype .xls in windows.

See post #5 here
http://www.mrexcel.com/forum/showthread.php?t=280472

 

[tuktuk]

hmmmm. get this:

if i have an instance of excel 07 open and then open another preexisting file save on the somewhere (LAN, desktop etc) it opens in the same instance.

if i go to the start menu and click on the 07 icon then another book opens. is this how the scheduler task would open it?

i've also tried the XLSX setting to mirror in the other thread. namely under File Types opens with excel,.....i dont believe there is a "Use DDE" box" in 2007 settings.

T