wksht name as current date - m-d-yy

wksht name as current date - m-d-yy
I'd like to add coding to an existing macro that names the current worksheet, based on the current date, i.e. m-d-yy format. I assume there's some date (object?) that will need to be set as a variable, from which I'll need to extract the month-day-year parts of the date, put them all into a string, and rename the worksheet? Just not familiar enough yet with which objects, properties, etc. to use to accomplish this. Can you help? Thanks!

Craig,

The line

ActiveSheet.Name = Format(Now, "m-d-yy")

should do what you want.

Andrew Taylor

craig_100 wrote:
> wksht name as current date - m-d-yy
> I'd like to add coding to an existing macro that names the current
> worksheet, based on the current date, i.e. m-d-yy format. I assume
> there's some date (object?) that will need to be set as a variable,
> from which I'll need to extract the month-day-year parts of the date,
> put them all into a string, and rename the worksheet? Just not familiar
> enough yet with which objects, properties, etc. to use to accomplish
> this. Can you help? Thanks!
>
>
> --
> craig_100
> ------------------------------------------------------------------------
> craig_100's Profile: http://www.excelforum.com/member.php...o&userid=29187
> View this thread: http://www.excelforum.com/showthread...hreadid=494142

That did exactly what I wanted. Thanks very much!