Fordraiders
asked on
copying files from one folder to another with specifics requirements
excel 2010 vba
vba code needed please
I have image files ina folder called :
D:\Images_2014\
I also have images on the C:\ drive: with folder structure
C:\Images_2014\<SUBFOLDERS >
1_JPG\
2_JPG\
3_JPG\
4_JPG\
5_JPG\
6_JPG\
7_JPG\
8_JPG\
9_JPG\
What I need:
From the D:\Images_2014\
If a .jpg file starts with say "1" THEN IT GETS PLACED INTO THE:
C:\Images_2014\1_jpg folder
Example:
1A1221.JPG
If a .jpg file starts with say "2" THEN IT GETS PLACED INTO THE:
C:\Images_2014\2_jpg folder
Example:
2AW123.JPG
etc... etc...
Thanks
fordraiders
vba code needed please
I have image files ina folder called :
D:\Images_2014\
I also have images on the C:\ drive: with folder structure
C:\Images_2014\<SUBFOLDERS
1_JPG\
2_JPG\
3_JPG\
4_JPG\
5_JPG\
6_JPG\
7_JPG\
8_JPG\
9_JPG\
What I need:
From the D:\Images_2014\
If a .jpg file starts with say "1" THEN IT GETS PLACED INTO THE:
C:\Images_2014\1_jpg folder
Example:
1A1221.JPG
If a .jpg file starts with say "2" THEN IT GETS PLACED INTO THE:
C:\Images_2014\2_jpg folder
Example:
2AW123.JPG
etc... etc...
Thanks
fordraiders
ASKER
batch will do fine...actually...will try it..
how does it know i'm copying from :
in a folder called :
D:\Images_2014\
how does it know i'm copying from :
in a folder called :
D:\Images_2014\
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
OK thanks..will let you know
ASKER
this script worked like a charm...Thanks
Glad I could help.
Here it is the batch file:
Open in new window