Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
save as error with no click
Hi all.
This ties in with another post, but so I don't confuse myself, I'm posting this as a separate entity. I have a macro that empties unused rows/columns, and then saves the workbook in a new directory. Actually, it does the save first, then "compacts" the workbook. I've nested this within a macro that runs through all of the files we have in a directory, once I activate it. There are 513 files. It runs well UNTIL..... 1- I hit an error because of some erroneous data in a workbook that I was not aware of, or some application defined or object defined error. Jokingly-- for all I know it just wants to eat a donut or something to irritate me...... 2- after stopping to find what the error is, I activate the macro again, and it starts over from scratch. What I'd initially done was to turn the application.displayalerts to false, so I would not need to keep an eye on it, everytime it found something it otherwise needed my input for. After realizing that I do not want to keep re-processing my files, I set the display alerts back to true, and when it gives me an alert telling me that I'd already saved a file, I click no, and I then get a save as error. So, my question is now-- How can I get it to continue processing files once I say no to saving a specific file? (I've already gone through about 1/8-1/4 of my 513 files, and do NOT want to keep redoing them if I get hung up somewhere with an error-- I'd like to pick up where I left off and go forward from there.) Thank you. Best. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
right click save as feature | Excel Discussion (Misc queries) | |||
VBScript to prompt Save on Cancel click | Excel Programming | |||
Disable Auto save on Right Click | Excel Discussion (Misc queries) | |||
why does right click on row bring up save as? | Excel Discussion (Misc queries) | |||
Auto-Click Save on Clipboard | Excel Programming |