View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LunaMoon LunaMoon is offline
external usenet poster
 
Posts: 97
Default Is there a way to force out other editors when Excel 2003 is inautomation mode?

Hi all,

I am using Windows scheduler to automate Excel tasks, every morning
4am...

Basically, my current implementation is:

1. Auto-open Excel sheet;
2. Run some macro, download some data;
3. Auto-save and close.

However, the automation fails when some other people including myself
are editing the Excel sheets ...

Is there a way to force out other editors when opening the sheet in
automation mode?

Thanks a lot!