Rename multiple files in a folder with a macro

Hi,

I have multiple files in a folder and I want to rename them automatically via a macro. I use Excel 2016.

BEFORE

The existing file names are:

Firstname Surname.html
OR
Firstname Surname SOMETEXT.html
OR
Firstname Surname SOMETEXT_SOMETEXT.html

AFTER

I would like the macro to rename the files to:

Firstname Surname _ Live.html
or
Firstname Surname SOMETEXT_SOMETEXT_Live.html

Can you help me with this request?

Thank you,
Ash

Add this code to a standard codemodule in the .xlsm file, and set a reference to MS Scripting Runtime. Save the workbook in the folder with all the html files to be renamed prior to running the macro. Of course, change SOMETEXT to the actual text that you have - if it isn't the same for all files, delete the first Name line and uncomment the second.

Please Login or Register  to view this content.

Try the following .. Put your files in a folder named "Test Folder" in the same path of thisworkbook

Please Login or Register  to view this content.

Did you save the workbook in the same folder? I used Book2.xlsm:

Capture.JPG

Capture after.JPG

Please Login or Register  to view this content.

This code requires a reference to MS Scripting Runtime - place the Excel Workbook in the root folder, and all the HTML files will be renamed:

Please Login or Register  to view this content.

Ok - take a look over there, too.

I am getting an error in the macro.

The error happens when there are special chars in file names:
Matt Taylor ☁
Александр БойкO
Андрей ОконникоB
Виталий ЩербаньA

Plus there could be other special chars, etc.

Please advise?

My system doesn't allow special characters, so I cannot test it. You should start a new thread to ask about that.