LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Work with my 97-2003 Excel version in Compatibility Mode? Quincy Excel Discussion (Misc queries) 0 January 6th 10 08:31 PM
MS Excel 2003: Cant exit design mode, whats the fix? Miker New Users to Excel 0 May 4th 09 11:51 PM
run setup in maintenance mode excel 2003 Anna Excel Discussion (Misc queries) 1 November 22nd 06 08:48 PM
MS Excel 2003 - inserting an editors name into a cell TP GS 180506 Excel Discussion (Misc queries) 3 May 18th 06 03:28 PM
Activate my Excel 2003 but it still runs in reduce mode atomicesar Excel Discussion (Misc queries) 1 July 23rd 05 07:34 PM


All times are GMT +1. The time now is 05:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"