Overwriting existing files

  • Thread starter Thread starter Luc Martens
  • Start date Start date
L

Luc Martens

How can I overwrite an existing file with the same name with the procedure
SaveAs in Visual Basic for Applications without the program asking me for
overwriting ("Yes, No, Annuleren").

Thanks

Luc
 
Luc,

Application.DisplayAlerts = False
.... your saveas code
Application.DisplayAlerts = True

hth,

Doug
 
Back
Top