If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Is there a way to force out other editors when Excel 2003 is inautomation mode?
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 |
#3
|
|||
|
|||
Is there a way to force out other editors when Excel 2003 is inautomation mode?
On May 5, 8:25*pm, Dave Peterson wrote:
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 This doesn't matter. No matter what I need to force out the other editors... They are my colleagues and they sometimes forget about closing out of the files before they leave the office... If I don't force them out, there will be always a "read/write notification" window popping up, asking "yes/no", then the whole automation procedure stuck there, defeating the purpose of automation. Any more thoughts? Thanks |
#4
|
|||
|
|||
Is there a way to force out other editors when Excel 2003 is inautomation mode?
So you would want to force the user to close the file -- even though you don't
know if the current changes should be saved or discarded? That sounds like a disaster for you, your co-worker, and your boss -- who's going to be upset that something got saved that shouldn't have -- or 8 hours of work was discarded and shouldn't have been. I think that this is a training issue. But if you look at Chip's site to see how to close a workbook after a given time of inactivity. http://www.cpearson.com/excel/TimedClose.htm (I can't say how much I think that this is a bad idea!) LunaMoon wrote: On May 5, 8:25 pm, Dave Peterson wrote: 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 This doesn't matter. No matter what I need to force out the other editors... They are my colleagues and they sometimes forget about closing out of the files before they leave the office... If I don't force them out, there will be always a "read/write notification" window popping up, asking "yes/no", then the whole automation procedure stuck there, defeating the purpose of automation. Any more thoughts? Thanks -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|