VB code to rename PDF File and Store it in Particular Folder

Job ID: 32995980

Budget: £20 – £250 GBP

Hi, I have some 1600 PDF statements and their current file name is their Employee ID. I am looking for a way to -

1. Rename the file to employee names (Employee name is currently in the Statement on Line 7) - or as shown in Excel File
2. Store PDF copy (with Employee Name as file name) in a folder of Line Manager.

Thank you.
Related categories: Visual Basic Excel Visual Basic for Apps VB.NET