Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VBA Modify Excel File Names in the Folder.

Status
Not open for further replies.

Salut39

Technical User
Aug 2, 2006
178
GB
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
 
Thanks Andy,

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

Yuri
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top