View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Martin X. Martin X. is offline
external usenet poster
 
Posts: 4
Default Help with ActiveWorkbook.SaveAs

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