Change pdf files names in folder with VBA

[Volkof]

Hello all,

i have this:

A-scan	B-Name
Scan01	GR18987564-Plat1
Scan02	GR18987564-Plat2
Scan03	SR-85-18987654654-PL1
Scan04	SR-85-18987654654-PL2
Scan05	GT6576846465-Plat1
Scan06	GT6576846465-Plat2
Scan08	GR18987798-Plat1
	GR18987798-Plat2
Scan07	GR18897-Plat1

<tbody>
</tbody>

This excel file will be in a folder where I have many subfolders containing pdf scans ex. Scan01, Scan 02... like in the column A.
I need Excel scan the folders and if finds a pdf named ex. Scan02, change the name from Scan to the name in column B. So first Scan05 will be GT6576846465-Plat1. A hard part is also with the extension. I don't want the file to be renamed GR18987564-Plat1.pdf because with the extension will be GR18987564-Plat1.pdf.pdf.
Any codes available?

Thank you very much and have a nice day!

 

[James006]

Hello,

You could take a look at following link :

https://www.mrexcel.com/forum/excel...l-vba-rename-files-directory.html#post3532077

HTH

 

[Volkof]

Thanks for the fast reply. I will try it and post further the errors