VBA Modify Excel File Names in the Folder.

[Salut39]

Hi, I have to change manually excel file names from one month to the next. (i.e. Jul to Aug)

Is there a Macro to select folder and change selected word in file name and change it to selected new name. Loop this for all files in a folder.
I have no knowledge of VBA, appreciate help.

Thanks
Yuri

 

[Andrzejek]

You may start here: How do I rename a file in VBA

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[Salut39]

Thanks Andy,

I certainly will have some fun. I'll give it a try.

Yuri

 

[Andrzejek]

That will get you to rename a file.

To point to the folder where those files are, you can use a Application.FileDialog(msoFileDialogFolderPicker)

You can use 2 text boxes where you can state:
1. Part of a file to be replaced (i.e. Jul)
2. With new part (i.e. Aug)


Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.