Marco to automatically replace existing file

[Guest]

I have created a script that will preview the content of an excel file as a
".htm" file. If I make changes to the Excel, and re-run the script, it asks
to replace the existing file. Does anyone know how to have it automatically
choose yes?

ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\btobin\Desktop\bt_test.htm",
FileFormat:=xlHtml, _
ReadOnlyRecommended:=False, CreateBackup:=False
ActiveWorkbook.WebPagePreview
Application.WindowState = xlMinimized
ActiveWorkbook.Save

 

[Guest]

try this
Application.DisplayAlerts = False 'Put this at beginning of code
Application.DisplayAlerts = True 'Put this at the end of code

 

[Guest]

That did it! Thanks!

try this
Application.DisplayAlerts = False 'Put this at beginning of code
Application.DisplayAlerts = True 'Put this at the end of code