Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change synthax of workbook-level names in one go
Dear Experts:
A workbook with several worksheets has numerous workbook-level names, which all have the following synthax: _##_###_##_## (e.g. _90_237_44_44) I would like to run a macro that changes all the above workbook-level names to the following synthax: ##-###-##-## (e.g. 90-237-44-44). That is the first underscore has to be dropped, all the other underscores have to be replaced with hyphens. Help is much appreciated. Thank you very muc in advance. Regards, Andreas |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change synthax of workbook-level names in one go
Before you do that, try creating a new name that follows that syntax -- maybe in
a test workbook. andreashermle wrote: Dear Experts: A workbook with several worksheets has numerous workbook-level names, which all have the following synthax: _##_###_##_## (e.g. _90_237_44_44) I would like to run a macro that changes all the above workbook-level names to the following synthax: ##-###-##-## (e.g. 90-237-44-44). That is the first underscore has to be dropped, all the other underscores have to be replaced with hyphens. Help is much appreciated. Thank you very muc in advance. Regards, Andreas -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change synthax of workbook-level names in one go
Names can't include dashes (or hyphens), and various other illegal
characters. Depending on the usage of your names, you might be able to create copies of the originals, following some new format, then do a search & replace of cell formulas in each sheet to update the new names. Might not be too difficult programmatically. However Names can be used in other places besides cell formulas, but only you would know about that. Before posting back, try doing what I suggested manually with one name, obviously having saved a backup. If you've only got a handful stick with it. Regards, Peter T "andreashermle" wrote in message ... Dear Experts: A workbook with several worksheets has numerous workbook-level names, which all have the following synthax: _##_###_##_## (e.g. _90_237_44_44) I would like to run a macro that changes all the above workbook-level names to the following synthax: ##-###-##-## (e.g. 90-237-44-44). That is the first underscore has to be dropped, all the other underscores have to be replaced with hyphens. Help is much appreciated. Thank you very muc in advance. Regards, Andreas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
workbook level name vs worksheet level name | Excel Programming | |||
Calling worksheet-level names using insert Autotext in Word | Excel Programming | |||
If - Then synthax | Excel Programming | |||
Duplicating worksheet-level names | Excel Discussion (Misc queries) | |||
Why, when I create workbook-level name does it jump it to Sheet-level ? | Excel Programming |