Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rename with more than 31 chars an Excel sheet
Hi. I need to rename my Excel sheets with long names, either manually or
using VBA, but I get the issue the names must be shorter than 31 chars. I can do it using an external application (QTP from Mercury), it uses it's internal datatable and I can export a sheet with a long name to an Excel workbook and when I open the workbook the sheet it's there with the long name, and works as any other sheet. But I am sure there must be a way to rename the sheets from Excel or VBA with long names. I don't understand why they (MS teams who developed Excel) put that prevention, if long names does not affect the sheet performance. :-S I hope an Excel or MS expert read this post, or anyone who knows how to do that, and I will be so thankful. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rename with more than 31 chars an Excel sheet
Israel,
I've never seen it done before. VBA will throw an error if you rename a sheet with more that 31 chars. Mike "Israel Valencia" wrote: Hi. I need to rename my Excel sheets with long names, either manually or using VBA, but I get the issue the names must be shorter than 31 chars. I can do it using an external application (QTP from Mercury), it uses it's internal datatable and I can export a sheet with a long name to an Excel workbook and when I open the workbook the sheet it's there with the long name, and works as any other sheet. But I am sure there must be a way to rename the sheets from Excel or VBA with long names. I don't understand why they (MS teams who developed Excel) put that prevention, if long names does not affect the sheet performance. :-S I hope an Excel or MS expert read this post, or anyone who knows how to do that, and I will be so thankful. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i rename a sheet if the rename tab is inactive? | Excel Worksheet Functions | |||
rename sheet tabs in excel | Excel Discussion (Misc queries) | |||
How to rename Excel Sheet with more characters? | Excel Discussion (Misc queries) | |||
VBA to rename sheet WITHIN Excel | Excel Programming | |||
I cannot rename my excel sheet? | Excel Worksheet Functions |