Append Text To Folder Name

[SimonHughes]

Hello, is it possible to change a folder name automatically? I have about 25 folders that I would like to append the name with the text "NHS". Is this possible or is it a manual job? TIA.

 

[Joe4]

You can do that with VBA. There are some old threads that deal with this, such as these:

VBA to rename folders in bulk

Hi I am trying to rename folders using VBA. The goal would be to do a batch update to rename existing folders with a standard naming convention. Ideally I would have the file path listed in one column in my spreadsheet (I already have a list) and then have the updated file path listed the...

www.mrexcel.com

Rename folders in VBA

I have an Excel file that does a lot of tasks using VBA,then makes a new folder named "New" in a specific directory. It then saves the file in that folder. That works great but I would like to be able to rename that folder to the same name as the Excel file which is in a specific cell in the...

www.mrexcel.com

If you need more specific help, you will need to provide more detail.

 

[SimonHughes]

Many thanks - I have had a look and using VBA is too worrisome for me. I really dont have a good grasp of it and am more concerned about making a mistake which could lead me to a world of pain. I should have realised that it would involved VBA before posting. But thanks anyway.

 

[Joe4]

You are welcome.

Yep - in Excel, the word "automatic" almost always means VBA will be needed!