activeworkbook.saveas -- overwrite without prompt 2

[LisaBee]

Again, another probably simple solution that the syntax eludes me. (and I honestly don't know enough about VBA help to understand its options).

I'm using ActiveWorkbook.SaveAs FileName:=LocalFileName

There are a few ocassions when I know that the filename already exists, but after making modifications to the worksheet, I want to save over the existing file. How can this be done automatically, without prompting the user "file already exists, do you want to overwrite - yes, no, cancel"?

Thanks very much

 

[PHV]

Have a look at the DisplayAlerts property:
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs FileName:=LocalFileName
Application.DisplayAlerts = True

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[LisaBee]

Absolutely works perfectly!!!

Thanks so much!