I have a program that periodically locks up when it's trying to save to a network location. Is there a way to start a 10 second timer before the save command followed by a cancel timer command after the save command? If the 10 seconds is reached you do a sendkey of the return key to cancel the save command and move on with the program. Does this exist? Can someone share an example?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How to kick out of a frozen save
- Thread starter Photomofo
- Start date
I have a program that periodically locks up when it's trying to save to a network location. Is there a way to start a 10 second timer before the save command followed by a cancel timer command after the save command? If the 10 seconds is reached you do a sendkey of the return key to cancel the save command and move on with the program. Does this exist? Can someone share an example?
Excel Facts
Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
L
Legacy 143009
Guest
I don't think this is achievable. You have to use
BeforeSave: If you use Application.Wait in this event, the app will wait for 10 sec. and then start to saving process.
AfterSave: You have to wait for saving event to finish in order to trigger the Enter action.
In both situations, it is quite impossible to run something during the saving process. Maybe someone may come up with a clever solution.
Application.Wait function. However there are only two events that you can use this function.BeforeSave: If you use Application.Wait in this event, the app will wait for 10 sec. and then start to saving process.
AfterSave: You have to wait for saving event to finish in order to trigger the Enter action.
In both situations, it is quite impossible to run something during the saving process. Maybe someone may come up with a clever solution.
Upvote
0
OK thanks... I thought there might be some sort of kickout command but if this isn't the case I'll see if I can use some logic around verifying the path first. It's not like the path isn't there because this save works 99% of the time.
Sure seems like there should be a built in function where there's a maximum time limit for how long the save should take.
Upvote
0
An alternative save may be another option according to this thread.
stackoverflow.com
ThisWorkbook.Activate
SendKeys "^s"
DoEvents
ThisWorkbook.Close
Too long saving time in Excel via VBA
Some unusal phenomenon started affecting my macro. I have a relatively big (13MB) excel workbook. ThisWorkbook.Save worked just fine. It took like 10 seconds to save the workbook (without any data
ThisWorkbook.Activate
SendKeys "^s"
DoEvents
ThisWorkbook.Close
Upvote
0
Similar threads
- Question
