How can I save a daysheet as today's date

[Elfego Baca]

I have a daysheet that automatically enters the date in cell D1 as
value(Today()). Now I would like to be able to automatically save the
sheet as the date in the form 01-24-07.

 

[Earl Kiosterud]

Elfego,

Format the cell. Format - Cells - Number Tab - Custom. mm-dd-yy, or
dd-mm-yy as you want it.

Be aware that when you open this workbook on a later date, the date
displayed will have changed. To lock it to the current date, Copy, then
Edit - Paste Special - Values.

 

[Gord Dibben]

When you say "sheet" do you mean workbook or worksheet?

Do you mean save the workbook with the date as name of workbook?

Do you mean save just one sheet as a new workbook with date as name?

Or just rename that worksheet as date?


Gord Dibben MS Excel MVP

 

[Elfego Baca]

I man the workbook

When you say "sheet" do you mean workbook or worksheet?

Do you mean save the workbook with the date as name of workbook?

Do you mean save just one sheet as a new workbook with date as name?

Or just rename that worksheet as date?


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Elfego

If your regional settings default date contains slash(/) marks, Excel won't
accept them.

Best to leave the cell reference out of it and just saveas current date.

Sub Rename_WkBk()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:=ThisWorkbook.Path _
& "\" & Format(Date, "mm-dd-yy")
Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub


Gord

 

[Earl Kiosterud]

Elfego,

It might be easier just to put in todays date with Ctrl + ;. Then press
Enter.