Date function 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

Date function

Returns a Variant (Date) containing the current system date. Syntax Date Remarks To set the system date, use the Date statement. Date, […]