Precede the statement with
Application.DisplayAlerts = False

"Martin X." wrote in message
...
Hello,

The line below saves the current workbook, but errors if I have an
existing
workbook with the same name already. Is there an additional parameter that
will overwrite the existing workbook with this new one? If not, how should
I
go about overwriting the existing workbook? I could put some code in to
check if the workbook name already exist and name the new workbook
appropriately, but I wanted to see if there was something simpler. Thanks.

objExcel.ActiveWorkbook.SaveAs strOutputFilePath

--
Regards,
Martin X.
MCSA: M