Macro code to change tab name

[TurboBeagle]

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.

[Dave Peterson]

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