Dear All,
I am try to Rename Multiple PDF files with the Excel sheet Data.
Column A -Contains ,Original PDF File Name
Column B -Contains, to be Rename File Name
My Pdf files were in the folder path-E:\test
I took the Vb code from our fourm only.
But when try to run the macro, it shows "Run time Error '53': "File Not Found.
Please help to solve.
Thanks In Advance.
Please Login or Register to view this content.
Last edited by arlu1201; 11-06-2012 at 09:34 AM.
The obvious and most likely explanation is a mismatch between the control sheet and the available file.
If you can't find that insert debug.print statements to show the value for path and the result of dir(path) for comparison in the immediate window.
Maybe:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Dear JB
Thanks for your input.
But it shows error as "Run-Time error '5",Invalid proceducre call or argument
Please Help.
Thanks in Advance.
Regards.
Prasanna
Your fpath is already imbedded into both of the strings in columns A:B, so you don't need to parse it out.
Please Login or Register to view this content.
Thanks Jb Its worked.
thanks a lot.
Regards
Prasanna
I have marked this thread solved for you.
In the future please select Thread Tools from the menu above and mark the thread as solved. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks