Ajit Kiran
Member
Hello guys!
Looking for a small VB code which can change the name of the worksheet in a workbook.
For eg., the below code needs to be tweaked out to show the last 2nd working day from today as a suffix to it automatically:
Looking for a small VB code which can change the name of the worksheet in a workbook.
For eg., the below code needs to be tweaked out to show the last 2nd working day from today as a suffix to it automatically:
Code:
Sheets("Sheet1").Name = "GRCOnedaily04112013"
Since today is 6th November (IST) the sheet must be renamed to 4th Nov as that's the 2nd last working day from today. Yet another eg., on Monday 4th Nov, the sheet must be renamed to "GRCOnedaily31102013"
Would that be possible pls? Thanks a ton for your help in advance!
Rgs,
Ajit Kiran
Would that be possible pls? Thanks a ton for your help in advance!
Rgs,
Ajit Kiran