Forum Discussion

Jimmy_Harper's avatar
Jimmy_Harper
Copper Contributor
Jun 08, 2021

Open 1 or many PDF files via hyperlink (1/row), save the PDF, then go to next row until complete

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  

No RepliesBe the first to reply

Resources