Workbook.SaveCopyAs method Archives - ExcelBaby

Learn

Excel Macro: Create a Backup of a Workbook with Current Date

This simple macro can backup your workbook with today's date as part of the file name in the Same folder. Get this VBA code now!

Date function Format function Workbook.SaveCopyAs method Workbook.Name property Application.ThisWorkbook property Workbook.Path property

Docs

Workbook.SaveCopyAs method

Saves a copy of the workbook to a file but doesn't modify the open workbook in memory. Syntax expression.SaveCopyAs (FileName) expression A […]

Workbook.SaveCopyAs method