I am trying to save a XLS file in HTML format without prompting me if I would like to overwrite the existing file. It will be the same file name every week.

' Save file
oExcel.ActiveWorkbook.SaveAs sNewFileName, xlHtml

==============================
Sub SaveAs([Filename], [FileFormat], [Password], [WriteResPassword], [ReadOnlyRecommended], [CreateBackup], [AccessMode As XlSaveAsAccessMode = xlNoChange], [ConflictResolution], [AddToMru], [TextCodepage], [TextVisualLayout])

Member of Excel.Workbook
==============================