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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel SaveAs to force overwrite of extant file 1
Save as, not overwrite 1
Allowing xlBook.SaveAs in Access code to overwrite existing workbook? 2
Create a new file, name it and overwrite an existing name without confimation 2
SaveAs Method 2
SaveAs to existing file 5
Export of select query data to excel in Access 2007 4
Method SaveAs with no overwrite YesNoCancel dialog 1

Back
Top