J Jim Cone Aug 3, 2007 #2 Sheets.Copy ActiveWorkbook.SaveAs "NewName" -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) <[email protected]> wrote in message Is there a way to save a workbook to a new name but not save the macro
Sheets.Copy ActiveWorkbook.SaveAs "NewName" -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) <[email protected]> wrote in message Is there a way to save a workbook to a new name but not save the macro