Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rename worksheet in macro
I download a file every day, I have a great macro that does a load of stuff
but have realised one shortcoming. Every day the original worksheets name tab (business system generated) includes the date, so it changes its name every day. When I ask my macro to select the tab and change the name as part of the required tasks, it will stop dead when tomorrow comes and the name has changed due to the new date. I'm an obsolute novice VB editor, but would be grateful if anyone can see a way around this other than getting IT to remove the date field from the tab name . |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rename worksheet in macro
You should try and reference the worksheet name tab as ActiveSheet.Name
ActiveSheet.Name = Format(Date, "mmddyy") "JBW" wrote: I download a file every day, I have a great macro that does a load of stuff but have realised one shortcoming. Every day the original worksheets name tab (business system generated) includes the date, so it changes its name every day. When I ask my macro to select the tab and change the name as part of the required tasks, it will stop dead when tomorrow comes and the name has changed due to the new date. I'm an obsolute novice VB editor, but would be grateful if anyone can see a way around this other than getting IT to remove the date field from the tab name . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't rename worksheet | Excel Discussion (Misc queries) | |||
new worksheet and rename from cell contents macro | Excel Worksheet Functions | |||
Using information from one worksheet, to rename inserted worksheet | Excel Worksheet Functions | |||
why can't I rename my worksheet? | Excel Discussion (Misc queries) | |||
Rename Macro | Excel Discussion (Misc queries) |