MrExcel Publishing
Your One Stop for Excel Tips & Solutions

visual basic SaveAs


Posted by Jonathan on April 04, 2001 4:04 AM

How do you save a spreadsheet already open as the same name? With the Saveas, I get the Overwrite question when trying to save.


Posted by Dave Hawley on April 04, 2001 4:27 AM

Hi Jonathan

Use:

Application.DisplayAlerts=False
'Your code
Application.DisplayAlerts=True


Dave

OzGrid Business Applications