I don't think so.

Maybe you can check to see if your procedure opened the file successfully in
read/write mode and continue -- or use application.ontime to try in a few
minutes.

Chip Pearson's site explains it:
http://www.cpearson.com/excel/OnTime.aspx

LunaMoon wrote:

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!

--

Dave Peterson