Hi,
need your help. A report needs to name a sheet according the current business date.
cob = 02/06/2008
ActiveSheet.Name = cob
Due to the '/' the macro shows an error.
As the cob is needed in this specific format for other parts in the macro, is there any command how the format can be changed to 20080602 for renaming the sheet?
i.e.
cob = 02/06/2008
ActiveSheet.Name = Numberformat(yyyymmdd, cob)
Any help is is very welcome.
Thanks
need your help. A report needs to name a sheet according the current business date.
cob = 02/06/2008
ActiveSheet.Name = cob
Due to the '/' the macro shows an error.
As the cob is needed in this specific format for other parts in the macro, is there any command how the format can be changed to 20080602 for renaming the sheet?
i.e.
cob = 02/06/2008
ActiveSheet.Name = Numberformat(yyyymmdd, cob)
Any help is is very welcome.
Thanks