View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Doug Glancy[_8_] Doug Glancy[_8_] is offline
external usenet poster
 
Posts: 63
Default 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