Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ActiveWorkbook.SaveAs | Excel Programming | |||
Set mySavedSummary = ActiveWorkbook.SaveAs( ....... | Excel Programming | |||
'ActiveWorkbook.SaveAs Filename' | Excel Programming | |||
ActiveWorkbook.SaveAs Problem | Excel Programming | |||
activeworkbook.saveas | Excel Programming |