Rename Multiple PDF Files using Excel VBA

I have a compressed file consisting of 900+ PDF files. I have an excel reference file that has column A (account #), column B (brokerage #), column C (Entity). Currently all these pdfs are names with the account Number in their title. But I want to rename them to their brokerage # and group the accounts in folders separated by their entities (4 different types).

Is there a macro function to rename a list of pdf's using the account # - replace it with the corresponding brokerage number and group the pdfs in their respective entity folders. I can unzip the original folder before writing any macro but preferably dont want to.

Any help is appreciated.
Thanks

need the filename format of the existing pdf,
and how you want it to look when renamed.

Current PDF name: TaxForm_1099Comp_2017_1815_"1234567"
New PDF Name: GSB="0000000000"+CSP="TOPACCOUNT"+DOC=M1+TT=12312016+D=2016_PPP1099PAIRED
The values in "" in the current PDF name are dynamic based on column A in the reference file
The values in "" in the new PDF name are dynamic based on columns B and C in the reference file

you will need to adjust the code to fit you.
in make new filename:

Please Login or Register  to view this content.

change the layout of your target filename.


change:
Sheets("Accounts").Activate
to the name of your excel sheetname with the accounts

in RenameFiles(),
change the Folder,"c:\temp\", where your pdfs are located

then run RenameFiles

Please Login or Register  to view this content.