View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michiel via OfficeKB.com Michiel via OfficeKB.com is offline
external usenet poster
 
Posts: 48
Default 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