M
Martin X.
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
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