Save As / Overwrite

  • Thread starter Thread starter Brent E
  • Start date Start date
B

Brent E

Good Day,

I am using macros in an Excel file perform sorts on data and save each sort
type as a seperate html file. I want to be able to use this macro to perform
automatic updates.

If I use the Workbook.SaveAs command, I am constantly prompted whether to
overwrite the existing file. I do not want this box to appear.

Is there a variant to the Workbook.SaveAs command that automatically
overwrites a file with the same file name without prompting for a
yes/no/cancel?

Thanks,
 
Hi,

Try something like this

Sub SaveMeeeee()
Application.DisplayAlerts = False
ThisWorkbook.SaveAs Filename:="MyFileName"
Application.DisplayAlerts = True
End Sub

Mike
 
Thanks worked. Thanks Mike.

Mike H said:
Hi,

Try something like this

Sub SaveMeeeee()
Application.DisplayAlerts = False
ThisWorkbook.SaveAs Filename:="MyFileName"
Application.DisplayAlerts = True
End Sub

Mike
Click to expand...
 
Back
Top