SaveAs Method

G

Geoff

Is there an argument or way to automatically overwrite an existing file
without receiving the overwrite confirmation message using the SaveAs method
 
F

Frank Kabel

Hi
enclose the SaveAs method with the following two statements:
Application.displayalerts = false
' your saveas method
Application.displayalerts = True
 
T

Tom Ogilvy

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
Auto file naming with macro 2
Private Sub Workbook_BeforeSave 2
Extracting Excel2007 data from structured Storage 0
Method SaveAs with no overwrite YesNoCancel dialog 1
Save as, not overwrite 1

Top