Macro code to change tab name
 

Does anyone know the vba code for changing a tab to the current date?
I have the code to create a string that is the current date, and have
applied that to other things, such as a new file name. I can't seem
to find how to apply that as a tab name.


Thanks.


--
TurboBeagle
------------------------------------------------------------------------
TurboBeagle's Profile: http://www.excelforum.com/member.php...o&userid=23415
View this thread: http://www.excelforum.com/showthread...hreadid=384694

Macro code to change tab name
 

activesheet.name = format(date,"yyyy_mm_dd")

is one way.

Remember that worksheet names can't include the slash character.



TurboBeagle wrote:

Does anyone know the vba code for changing a tab to the current date?
I have the code to create a string that is the current date, and have
applied that to other things, such as a new file name. I can't seem
to find how to apply that as a tab name.

Thanks.

--
TurboBeagle
------------------------------------------------------------------------
TurboBeagle's Profile: http://www.excelforum.com/member.php...o&userid=23415
View this thread: http://www.excelforum.com/showthread...hreadid=384694

--

Dave Peterson