Team
I am using MS 2010 and please tell me know how to rename multiple (more than 100) PDF files which in a folder as per the list in an excel spreadsheet. for example, I have contract agreement paper in PDF format for 100 employees and I have their employee ID numbers, last name, first name in a excel spreadsheet. I have to rename all the pdf files with the employee number_a commen name as "Contract Agreement" (123456_Contract Agreement)
Hi Manil
try the attached file and i hope this will work perfectly , just change the file path
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
Re: Rename Multiple PDF files in a folder per the list in Excel spreadsheet
Thank you very much! i tried many but it worked perfectly!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks