Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting Task Scheduler To Use Current Excel Session When Opening F
I am using the Task Scheduler to open an Excel file at timed intervals. The
problem is the Task Scheduler always opens a new session of Excel even when Excel is already running. Is there any way to get the Task Scheduler to use the current session of Excel to open the file if Excel is already running? Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting Task Scheduler To Use Current Excel Session When Opening F
Yes. Consider using the OnTime method within Excel to do the scheduling
rather than task manager. Another option is if you are running a macro each time Task Manager starts Excel, then have the macro close the application when it is done. -- Gary's Student "Carl" wrote: I am using the Task Scheduler to open an Excel file at timed intervals. The problem is the Task Scheduler always opens a new session of Excel even when Excel is already running. Is there any way to get the Task Scheduler to use the current session of Excel to open the file if Excel is already running? Thanks in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting Task Scheduler To Use Current Excel Session When Opening F
The first thing I'd try...
Sometimes one of these works when you're having trouble with double clicking on the file in windows explorer: Tools|Options|General|Ignore other applications (uncheck it) --- or --- Close Excel and Windows Start Button|Run excel /unregserver then Windows Start Button|Run excel /regserver The /unregserver & /regserver stuff resets the windows registry to excel's factory defaults. If neither of them worked, then I think I'd use the task scheduler to start a ..vbs script that does what I want. It could find an already running instance of excel or start a new one if excel isn't running. Something like this: '------------------ dim myXL dim myWkbk Dim XLWasRunning xlwasrunning = true On Error Resume Next Set myXL = GetObject(, "Excel.Application") If Err.Number = 429 Then set myXL = createobject("excel.application") xlwasrunning = false end If on error goto 0 myxl.visible = true 'nice for testing set mywkbk = myxl.workbooks.open("C:\my documents\excel\book1.xls") mywkbk.worksheets(1).range("a1").value = "Changed from VBS" mywkbk.close true 'or false to not save changes if xlwasrunning = false then myxl.quit end if set mywkbk = nothing Set myxl = nothing '------------------- Save it as a NiceName.VBS Carl wrote: I am using the Task Scheduler to open an Excel file at timed intervals. The problem is the Task Scheduler always opens a new session of Excel even when Excel is already running. Is there any way to get the Task Scheduler to use the current session of Excel to open the file if Excel is already running? Thanks in advance. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening Excel and chosen file from Explorer | Setting up and Configuration of Excel | |||
Probelm opening an excel 2000 file in excel 2003 | Excel Discussion (Misc queries) | |||
Can't alt-tab between Excel workbooks in one session. Help! | Excel Discussion (Misc queries) | |||
Opening and saving Excel 2003 file from Excel 97. | Excel Discussion (Misc queries) | |||
OPENING TWO DIFFERENT EXCEL PROGRAMS | Excel Discussion (Misc queries) |