Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Using Excel 97 SR-1.
I am using ActiveWorkbook.SaveAs to save an ".xls" file and I cannot find any documentation on how to handle file-already-exists errors. My intent is to try and save the file but if the filename is already used then to alter the filename and save again, repeating with different filenames until either the SaveAs works or the code chooses to give up. Currently, Excel pops up a message asking whether I want to replace the file, after clicking "no" I get another popup asking whether I want to debug the code. I do not want any pop ups. I just want to handle the file-already-exists case in the code. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SaveAs and File Exists | Excel Programming | |||
How check for No/Cancel Button when SaveAs and file already exists? | Excel Programming | |||
Saveas where file already exists | Excel Programming | |||
activeworkbook.saveas | Excel Programming | |||
SaveAs command when a file already exists? | Excel Programming |