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

.