Supposing I have 3 empty folders on my desktop named "1", "2" and "3" and another folder named "docs" containing 18 files - 9 .tifs and 9 .txts.
Using VBA in Excel, how could I move the files from "docs" into the folder who's name is contained within the filename?
For example, after running the macro, I would end up with:
Folder "1" contains john1.tif, john1.txt, paul1.tif, paul1.txt, mark1.tif and mark1.txt
Folder "2" contains matthew2.tif, matthew2.txt, luke2.tif, luke2.txt, peter2.tif and peter2.txt
Folder "3" contains james3.tif, james3.txt, william3.tif, william3.txt, robert3.tif and robert3.txt
Hope you can help. Thanks.
Using VBA in Excel, how could I move the files from "docs" into the folder who's name is contained within the filename?
For example, after running the macro, I would end up with:
Folder "1" contains john1.tif, john1.txt, paul1.tif, paul1.txt, mark1.tif and mark1.txt
Folder "2" contains matthew2.tif, matthew2.txt, luke2.tif, luke2.txt, peter2.tif and peter2.txt
Folder "3" contains james3.tif, james3.txt, william3.tif, william3.txt, robert3.tif and robert3.txt
Hope you can help. Thanks.