Hi, Could someone please help me out with a Excel VBA macro for copying text files from different folders (Paths specified in a input text file) to the specified destination folder and archive it in *zip format.. Please find below, the conditions given herewith.

Conditions:
With the click of a drop down list in GUI, please read in 'INPUT' text file

In the Input text file, paths for individual text files will be specified along with the keyword ‘INCLUDE’ (i.e., INCLUDE 'D:/test1/a1.txt', etc.,) and save them all in the specified destination folder D:/testfinal/
and archive all files with the file name as "copy_all_files_sub_folders.zip"

Files to be copied:

D:/test1/a1.txt

D:/test2/b2.txt

D:/test3/c3.txt

D:/test4/d4.txt

D:/test5/e5.txt

D:/test6/f6.txt

D:/test7/g7.txt

to the specified location D:/testfinal/ and archive all files as "copy_all_files_sub_folders.zip"

Thanks in Advance,
Prakash