Overwriting existing files
Luc,
Application.DisplayAlerts = False
.... your saveas code
Application.DisplayAlerts = True
hth,
Doug
"Luc Martens" wrote in message
...
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
|