Overwriting existing files
 

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

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