Sheet tabs with Date and Time

[JT]

I would like to name a sheet tab with the current date and
time using the NOW or DATE and TIME commands. But I am
having some problems with the (/) and ) in the sheet tab.

I can replace the (/) with a (-) but haven't found a
solution for the) without the time looking goofy.
Appreciate the help.

 

[Ron de Bruin]

Hi JT

Not pretty but I also use the - for the time

ActiveSheet.Name = Format(Now, "dd-mm-yy h-mm-ss")

 

[Bob Phillips]

You just can't use / or : in a sheet name, so you will have to use something
you understand. You could use a dot . for the time.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[David McRitchie]

Formatting with the year first so you can sort sheetnames,
ActiveSheet.Name = Format(Now, "yyyy-mm-dd_hhmm")
would make a lot more sense to me.

or for a files the filenames in a directory.
fname = "c:\mybackup\B" & Format(Now(), "yyyy_mmdd") & ".txt"

A macro to sort worksheets can be found at
http://www.mvps.org/dmcritchie/excel/buildtoc2.htm#sortallsheets

 

[count]

Hi,
For time separator try using Chr(166) - looks ok, pretty much like some
alarm radio display...
hth
Paul