Good evening Gurus,
So.... I have a folder with 100 PDF's saved and I want to move each individual file, from this source folder to an individual folder. (I can create the folders before or have the VBA create them for me)
So I would have:
I have 100 PDF files in a folder 'Source',
I have the list of these PDF file names in excel In Col A
I have a list of the folders names where i want each one to move to in Col B.
Thanks
Sam
Try this:
Please Login or Register to view this content.
Regards,
Thangavel D
Appreciate the help? CLICK *
Assuming:
1) Target directories already exist.
2) Filenames in column A have the .pdf extension present
3) The fullpath in column B has the backslash at the end.
then this will do.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
try
need to enter complete path with filename of source and target folder in Column A and B respectivelyPlease Login or Register to view this content.
Last edited by mohan.r1980; 12-07-2018 at 06:46 AM.
Regards,
MohanS
"Perfection is not attainable, but if we chase perfection we can catch excellence." - Vince Lombardi
You can simply say thanks by clicking "*Add Reputation" icon
Thank you all - sorted. Used a combination of things. :-)
Glad to help and thanks for rep+.
Your Welcome and thanks for rep++.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks