Ignore the 'file in use message' when opening Excel
 

Hi all,

I am scheduling an Excel workbook using the Scheduler Tool of Windows.
It just calls an Excel workbook, which opens, does some autorun processing
and closes again.

This works well, except when I have excel already open. In that case another
instance of Excel is opened (by the scheduler) and I get the "File in Use"
popup stateing that my PERSONAL.XLS is locked for editing. And gives me a
chance to cancel (button). A logical thing but unhandy in this context.

Is there a way to ignore this message or to add an extra parameter to the
call of the worksheet to prevent the message, or to automatically apply
cancel?

Thanks!

M.

--
Message posted via http://www.officekb.com

Ignore the 'file in use message' when opening Excel
 

Within Excel I'd use:

Application.DisplayAlerts = False
'code to open the workbook
Application.DisplayAlerts =True

in the scheduler, are you running this as a .vbs file? If so, consider
something like (untested):
Set objExcel = CreateObject("Excel.Application")
objExcel.DisplayAlerts=False
Set objWorkbook = objExcel.Workbooks.Open("C:\path\filename.xls")
objExcel.DisplayAlerts=True
objExcel.Run "MacroName"
objExcel.ActiveWorkbook.Save
objExcel.ActiveWorkbook.Close(0)
objExcel.Quit

If that doesn't help, consider posting your code where you instantiate
Excel, that might help draw more answers.

Keith

"Michiel via OfficeKB.com" wrote:

Hi all,

I am scheduling an Excel workbook using the Scheduler Tool of Windows.
It just calls an Excel workbook, which opens, does some autorun processing
and closes again.

This works well, except when I have excel already open. In that case another
instance of Excel is opened (by the scheduler) and I get the "File in Use"
popup stateing that my PERSONAL.XLS is locked for editing. And gives me a
chance to cancel (button). A logical thing but unhandy in this context.

Is there a way to ignore this message or to add an extra parameter to the
call of the worksheet to prevent the message, or to automatically apply
cancel?

Thanks!

M.

--
Message posted via http://www.officekb.com

.

Ignore the 'file in use message' when opening Excel
 

Hi Keith,

Thanks for your answer.
Unfortunately this will not work here.
The message that Excel finds the personal.xls being blocked "event" occurs
even before the code is kicksin. So, even when I did this the popup keeps on
appearing.

M.

ker_01 wrote:
Within Excel I'd use:

Application.DisplayAlerts = False
'code to open the workbook
Application.DisplayAlerts =True

in the scheduler, are you running this as a .vbs file? If so, consider

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/201002/1

Ignore the 'file in use message' when opening Excel
 

Additional,

Keith, triggered by your VBS question/suggestion I tried to start Excel via
VBS instead of directly calling the xls file, and that did do the trick.

Once mo Thanks for your help!

M.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/201002/1