xlUser
02-20-2012, 09:11 AM
Hi,
I have several folders and sub folders each containing files that I would like to consolidate into one central folder.
So for example my main folder is called test sitting at
c:\Test
Within this folder I have several folders: D1, D2, D3
c:\Test\d1
With each one of these folders I have another folder called data. And it is within this folder where the files that I wiould like to consolidate into one place reside (in this case excel files). So there are three levels of folders:
c:\Test\d1\data\Actual Files
c:\Test\d2\data\Actual Files
c:\Test\d3\data\Actual Files
c:\Test\d4\data\Actual Files
ETC
I would like to copy the files from each "data" folder into one main central folder (e.g folder called All) or into the test folder itself.
I've searched the internet on trying to find an example to do this but have been unsuccessful, hope someone can help.
Thanks,
Excel User
I have several folders and sub folders each containing files that I would like to consolidate into one central folder.
So for example my main folder is called test sitting at
c:\Test
Within this folder I have several folders: D1, D2, D3
c:\Test\d1
With each one of these folders I have another folder called data. And it is within this folder where the files that I wiould like to consolidate into one place reside (in this case excel files). So there are three levels of folders:
c:\Test\d1\data\Actual Files
c:\Test\d2\data\Actual Files
c:\Test\d3\data\Actual Files
c:\Test\d4\data\Actual Files
ETC
I would like to copy the files from each "data" folder into one main central folder (e.g folder called All) or into the test folder itself.
I've searched the internet on trying to find an example to do this but have been unsuccessful, hope someone can help.
Thanks,
Excel User