wksht name as current date - m-d-yy

  • Thread starter Thread starter craig_100
  • Start date Start date
C

craig_100

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete sheets code error requires object 2
Date Validation 1
Date Variable 6
Preserving date format in VB 3
Unusual date problem 1
Text Box date format dd/mm/yy not mm/dd/yy 3
Access 2 Digit year in Access Text Box 3
Date in text box reading mm/dd/yy instead of dd/mm/yy 1

Back
Top