SaveAs Method

  • Thread starter Thread starter Geoff
  • Start date Start date
G

Geoff

Is there an argument or way to automatically overwrite an existing file
without receiving the overwrite confirmation message using the SaveAs method
 
Hi
enclose the SaveAs method with the following two statements:
Application.displayalerts = false
' your saveas method
Application.displayalerts = True
 
sFile = "C:\myfolder\Myfile.xls"
On error resume next
kill sFile
On error goto 0
activeworkbook.SaveAs sFile
 

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
Overwriting existing files 1
Overridding the "already exists" message with the SaveAs method 4
Method SaveAs with no overwrite YesNoCancel dialog 1
Extracting Excel2007 data from structured Storage 0
Private Sub Workbook_BeforeSave 2
Save as, not overwrite 1
Force a SaveAs 3

Back
Top