How do I overwrite an existing file? 1

[LonnieJohnson]

I use this line of code to save an excel workbook.

    .ActiveWorkbook.SaveAs FileName:=strFileSave

However, it the file already exist it ask me if I want to overwrite it. How can I do it?

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[PHV]

.DisplayAlerts = False
.ActiveWorkbook.SaveAs FileName:=strFileSave
.DisplayAlerts = True

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[LonnieJohnson]

Thanks.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!