content list & rename

[MEIR]

Hello everyone,
I have a folder with documents (PDF, JPEG, DOC, XLS)
The formality required software that transfers content.
And rename the document
For example,
I have a document found in C: \ Users \ new data
Document: PDF.1234
vba folder leads to a list of column A
Column B the names of the new
VBA rename the folder and Bea new link




old path
Doc Name
New Name
New path


C:\Users\new data\1234.pdf
1234
987
C:\Users\new data\987.pdf





Thanks