Add the cell value to existing name

I want to add cell value to existing name of excel worksheet
Like Old Excel file name + Cell value

I want to do this for all the worksheets in a folder.
Need updation in Bulk


Please help

Originally Posted by alansidman

A couple of Questions
1. Is the Cell Value located on the Same Sheet in every file? Provide Sheet Name
2. Is the Cell Value located in the same Cell in each sheet? Provide Cell Address
3. Are all files .xlsx files

1. Yes. sheet1
2. Yes. A2
3. All are xlsx.

It is giving path/File Access error. Runtime error 75. on following line

```Name oName As nName```

Hi there,

See if the following code does what you need:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M


@alanisdman: I think the main problem was that your code was trying to rename the workbook while it was still open.

Many thanks for the Reputation increase - much appreciated!