I want to copy files located in multiple directories (source folders) that match a partial value in column 1 of sheet 1. The code i have works if all the files are in the source folder but will not locate further down in sub directories. Here is my code. Any help would help tremendously.
Sample directory
FROM
E:\P25\1000\
E:\P25\2000\ and so on to E:\P25\100000\
To
C:\temp\Data2\
Please Login or Register to view this content.
This looks like it should work, untested:
Please Login or Register to view this content.
Last edited by JBeaucaire; 12-17-2012 at 04:43 PM.
_________________
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!)
running into a Path/File access error
FileCopy sSrcFolder & f, sTgtFolder & f
What are the values at the DEGUB moment of:
sSrcFolder
sTgtFolder
f
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks