Hello excel community, i have a project of where i have to rename 7600 files within a folder. I have been able to find a way to create a macros that will extract those file names into Excel, but my problem now is how can i get those renamed files names back into the folder and reflect the name changes???
You need to explain some more. I am not able to understand your question.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
ok, i have 7600 pdf files that i need renamed with a file specific name. i used a macros formula in excel to extract the file names into a workable format. i was able to rename them successfully in excel, but i am stuck now on how i can extract those file names from excel back into the original file folder where the 7600 pdf exist. Does this explain a lil better?
You can't really. How is Excel supposed to know which of your amended file names relates to the original filename?
i think there is a way to do it thru DOS, but i am not sure of the process to accomplish that.
You haven't answered how you relate the old file names to the new ones. Without that no program will be able to do it
the old file names are listed as " 99999,smith,john,010111.pdf ", for our upload process i have to remove the commas and replace with spaces, otherwise the file will not upload to our system. i have removed the commas and added the spaces in excel and that is the only changes between the old and new file name. so the file names look like this now, " 99999 smith john 010111.pdf ", does this help clarify
I'd just run:
Please Login or Register to view this content.
thanks, i will try this and see how it works.
---------- Post added at 09:20 AM ---------- Previous post was at 09:05 AM ----------
this gave me a run time error
What's the error?
run-time error '53'
file not found
It's pretty self explanatory, it hasn't found the file. Is the filepath correct? Have you included the slash on the end of the directory name?
i would suggest taking a look on the net for a file re-namer...there are plenty of free 1's out there. the better 1's will let you specify how you want to change the file name, and what you want to add and where etc
that will be done without any input/interaction from excel
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hey brascoeuw,
I was searching for a macro that would import file names into Excel. It seems like you have one. Would you mind giving it to me? Thanks!
Please Login or Register to view this content.
Last edited by Cutter; 08-27-2012 at 11:48 AM. Reason: Added code tags
Thanks so much!! Saved me from a life with Carpel Tunnel Syndrome !!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks