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
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