RENAME SHEET WITH CELL VALUE UNTIL BRACKETS

[xenios]

Hi, hope somebody can help me.
Need to rename workbook sheets with cell value using macros, as it's about 300 sheets.
The problem is I have for example the name TEST1 (125) MY NAME, and need the sheet to be renamed only withe text before the 1st bracket.
Is there a way to do it with macros?

 

[Fluff]

You need to copy the code for the function as well.

 

[xenios]

that sub procedure is calling the function ExtractNthWord. You need to add that. Take a screenshot of what the error is showing when the function is inserted.

The error page attached. What do you mean by " to add that"?

 

[xenios]

that sub procedure is calling the function ExtractNthWord. You need to add that. Take a screenshot of what the error is showing when the function is inserted.

"ExtractNthWord. You need to add that " what do you mean by that, do I need to add something extra?
The screenshot attached.

 

[Fluff]

That code is looking at the name of the sheet, not a cell value.
Can you answer my question in post#8

 

[xenios]

Hi & welcome to MrExcel.
Which cells are the new names in & which cells are the current names in?

The name in the cell TEST1 (125) MY NAME
The name tha should have the sheet TEST1

Thank you

 

[Fluff]

That does not answer my question.
Please read post#8 & answer it.

 

[xenios]

You will need to have a list of the current sheet names & a list of the "TEST1 (125) MY NAME" values so we know what sheet should be renamed.
Do you have a list like that & if so where is it?

All sheets have to be renamed, initailly they have names Sheet1, sheet2,..
I can have the list but, the thing is it won't always correspond to the range of the sheets.
After I will have to do the list from the initial big name of the sheet, or from the sheet name, didn't figure out exactly how it's gonna work.

 

[Fluff]

Where do you have the values like "TEST1 (125) MY NAME"?
Does it matter which sheet is renamed TEST1?

 

[xenios]

You will need to have a list of the current sheet names & a list of the "TEST1 (125) MY NAME" values so we know what sheet should be renamed.
Do you have a list like that & if so where is it?

Sending you the picture how it should look like.

 

[Fluff]

But that sheet already has the correct name.