Hi Guys
My script is
______________________________________________________________________________
__________________________________________________
Please Login or Register to view this content.
I want it to distingush between files by looking for 1s#3 in the filename
files have very long names and vary by date and a possibility of 1s#1, 1s#2, 1s#3 and 1s#5.
the script is to move them into their respective folders as they are all jumbled together.
Many thanks in advance
James
Welcome to the forum.
I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.
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]
So the macro above is not suited for moving multiple randomly named files from one known location to multiple other locations.
What I would need to see is:
1) Sample complete filenames
2) The exact list of search strings and matching target destinations
_________________
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!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks