Amenolakaky
New Member
- Joined
- Feb 17, 2022
- Messages
- 14
- Office Version
- 2016
- Platform
- Windows
Hello All,
I have something will save my time but i cant write the code.
I have a list of shipments numbers in excel sheet
also i have a huge folder with subfolder and each subfolder names as the shipment number is the excel sheet.
Every folder has a ""PDF OR JPG" files.
for example print first paper contain of "AX000000001" Then print all files in this folder as the below.
this task takes one day just to print the shipment numbers and copy of these contents
I appreciate if someone provided me with something can help.
I have something will save my time but i cant write the code.
I have a list of shipments numbers in excel sheet
also i have a huge folder with subfolder and each subfolder names as the shipment number is the excel sheet.
Every folder has a ""PDF OR JPG" files.
the result will be
I need to make a macro to get the value from column A and search in the huge folder as the below then open it and print all the items in this folder.for example print first paper contain of "AX000000001" Then print all files in this folder as the below.
this task takes one day just to print the shipment numbers and copy of these contents
I appreciate if someone provided me with something can help.