G Guest Jan 27, 2004 #1 I want VBA to save a file using SaveAs and have it replace an existing file. How do I make it not display the dialog box telling me that the file already exists and asking if I want to replace it?
I want VBA to save a file using SaveAs and have it replace an existing file. How do I make it not display the dialog box telling me that the file already exists and asking if I want to replace it?
D Don Guillett Jan 27, 2004 #2 application.displayalerts=false -- Don Guillett SalesAid Software (e-mail address removed) Bill said: I want VBA to save a file using SaveAs and have it replace an existing Click to expand... file. How do I make it not display the dialog box telling me that the file already exists and asking if I want to replace it?
application.displayalerts=false -- Don Guillett SalesAid Software (e-mail address removed) Bill said: I want VBA to save a file using SaveAs and have it replace an existing Click to expand... file. How do I make it not display the dialog box telling me that the file already exists and asking if I want to replace it?
G Gord Dibben Jan 29, 2004 #3 Bill Application.DisplayAlerts = False 'your save as code goes here Application.DisplayAlerts = True Gord Dibben Excel MVP
Bill Application.DisplayAlerts = False 'your save as code goes here Application.DisplayAlerts = True Gord Dibben Excel MVP
