ISO Script for MS Excel report listing weblinks with pdf images to save image files as separate files with designated filenames

Inputs description: 1. MS Excel report with a batch of documents and weblinks leading to pdf image of each document. 2. Each batch report has up to 1000 rows. 3. Each batch report has a unique batch ID in the header of the report. 4. Documents are listed in rows, each document has a separate raw. 5. Each document has a unique document ID located in a designated column in the report. 6. Each document has image weblink listed in a designated column (initially formatted as text string, not hyperlink). 7. Weblink leads to the document image on image portal in pdf format. Output requirements option 1: 1. Automate the process of opening image links contained within the batch report and saving each document as separate pdf file using unique document ID from each row in the report (input #5 above) as filename for corresponding document image. 2. Autogenerate batch image folder on hard drive or shared drive, folder name should equal report batch ID (input # 3 above). 3. Save all pdf images from the batch report in the generated folder. Output requirements option 2: Identical requirements as option 1, but save files in .tif format instead of pdf format.