• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copying files from a subfolder to a folder

Alsoone

New Member
Hi,

I have to copy all .pdf files from the subfolder Test to a designated folder called All_Tests_Reports that resides on the path F:\Research\All_Test_Reports.

The subfolder Test is located under the following folders:
Table01\Service\Test.


There are 1000 Table folders named from Table01 to Table1000 and each table folder has a Test subfolder.

I have a list of selected Table folders from which to extract these .pdf files.
The list is as follows:
Table01
Table023
Table112
Table123
Table132
Table342
Table549
Table675
Table874
Table912
Table913
Table914
Table919
Table998

All .pdf files form the Test subfolders that reside under the above tables are to be copied to the folder All_Tests_Reports

I know it is possible using EXCEL VBA but my VBA knowledge is too elementary to do this.

Thanks

Alsoone
 
Back
Top