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
T Trevor Shuttleworth Jan 27, 2004 #2 Bill Application.DisplayAlerts = False ' your code Application.DisplayAlerts = True Regards Trevor 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?
Bill Application.DisplayAlerts = False ' your code Application.DisplayAlerts = True Regards Trevor 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?
