Change pdf files names in folder with VBA

[Volkof]

Hello all,

i have this:
[TABLE="width: 500"]
<tbody>[TR]
[TD]A-scan[/TD]
[TD]B-Name[/TD]
[/TR]
[TR]
[TD]Scan01[/TD]
[TD]GR18987564-Plat1[/TD]
[/TR]
[TR]
[TD]Scan02[/TD]
[TD]GR18987564-Plat2[/TD]
[/TR]
[TR]
[TD]Scan03[/TD]
[TD]SR-85-18987654654-PL1[/TD]
[/TR]
[TR]
[TD]Scan04[/TD]
[TD]SR-85-18987654654-PL2[/TD]
[/TR]
[TR]
[TD]Scan05[/TD]
[TD]GT6576846465-Plat1[/TD]
[/TR]
[TR]
[TD]Scan06[/TD]
[TD]GT6576846465-Plat2[/TD]
[/TR]
[TR]
[TD]Scan08[/TD]
[TD]GR18987798-Plat1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]GR18987798-Plat2[/TD]
[/TR]
[TR]
[TD]Scan07[/TD]
[TD]GR18897-Plat1[/TD]
[/TR]
</tbody>[/TABLE]


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