Save As-Overwrite existing File

[loulorisgomez]

Anyone have recommendations on how to avoid getting an error when a user tries to rename a file the user is initially trying to save? My file name is stored in cell 3,4. The code then takes whatever is in that cell and uses it as the file name to save. This code works fine if the file doesn't exist. If it does exist and the user does not overwrite the existing file and chooses to rename the file something else I then run into a problem. Perhaps there is a better way to do the code to get the same results.

Please Login or Register  to view this content.

***this is the function

Please Login or Register  to view this content.

at the top of my module is

Please Login or Register  to view this content.

[jayinthe813]

If your problem is dealing with the alerts, you can disable the alerts before you save by using:

Please Login or Register  to view this content.

And then re-enable them with

Please Login or Register  to view this content.

It should just overwrite the file

[loulorisgomez]

That could work. I'm not sure if writing over a file is the best idea but I think I may try that for a while. Any other ideas are appreciated.

Thank you.