RE: Save As / Overwrite

Thanks Mike,

I think that'll work. I'll let you know momentarily.

"Mike H" wrote:

Hi,

Try something like this

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

Mike

"Brent E" wrote:

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,
.

Relevant Pages

  • RE: Save As / Overwrite
    ... I am using macros in an Excel file perform sorts on data and save each sort ... If I use the Workbook.SaveAs command, I am constantly prompted whether to ... overwrite the existing file. ...
    (microsoft.public.excel.misc)
  • Re: Copying silently.
    ... command was in a batch file, but I'd like it to be one command on the ... Is there a switch to copy that means "Keep quite unless the source ... Do you want the Copy to continue (i.e. overwrite) ... windoze & enable you to call up all sorts of Operating ...
    (uk.people.silversurfers)
  • Save As / Overwrite
    ... I am using macros in an Excel file perform sorts on data and save each sort ... If I use the Workbook.SaveAs command, I am constantly prompted whether to ... overwrite the existing file. ...
    (microsoft.public.excel.misc)
  • RE: Save As / Overwrite
    ... I am using macros in an Excel file perform sorts on data and save each sort ... automatic updates. ... If I use the Workbook.SaveAs command, I am constantly prompted whether to ... overwrite the existing file. ...
    (microsoft.public.excel.misc)
  • RE: Save As / Overwrite
    ... "Brent E" wrote: ... automatic updates. ... If I use the Workbook.SaveAs command, I am constantly prompted whether to ... overwrite the existing file. ...
    (microsoft.public.excel.misc)
Loading