Jun 08 2021 06:47 AM
I need to open 1 or many PDF files via hyperlink (1 hyperlink per row in column T), save this PDF using a the file name from column E to a specific folder, then go to next row until complete. There could be 100s of hyperlinks in 1 spreadsheet. I need the macro code to accomplish. I can opened the files but I do not yet a way to save these PDF files to the selected folder using the desired file name. The general steps are:
1) Open Excel
2) Click on hyperlink in field cell "T2" to open pdf file "123456.PDF", after "123456.PDF" is open,
3) Save "123456.PDF" to a selected folder c:/files/pdfs/ and change the name of "123456.PDF" to "WI-123456.PDF" resulting in newly named pdf in folder c:/files/pdfs/WI-123456.PDF
4) Go to cell "T3" and perform again
5) Go to cell "T4" and perform again
6) Keep performing until there are no more rows of data