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