MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Using SaveAs to overwrite existing files


Posted by Keith Willis on November 21, 2001 1:07 AM

Is there any way in VBA to do this without getting the warning dialog that i`m about to overwrite an existing file?


Posted by Tom Morales on November 21, 2001 10:36 AM

Keith:
Insert the line:

Application.displayalerts = False

before you save the file. After saving it, add the line:

Application.displayalerts = True

Tom