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

%3CLINGO-SUB%20id%3D%22lingo-sub-2426563%22%20slang%3D%22en-US%22%3EOpen%201%20or%20many%20PDF%20files%20via%20hyperlink%20(1%2Frow)%2C%20save%20the%20PDF%2C%20then%20go%20to%20next%20row%20until%20complete%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2426563%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20open%201%20or%20many%20PDF%20files%20via%20hyperlink%20(1%20hyperlink%20per%20row%20in%20column%20T)%2C%20save%20this%20PDF%20using%20a%20the%20file%20name%20from%20column%20E%20to%20a%20specific%20folder%2C%20then%20go%20to%20next%20row%20until%20complete.%20There%20could%20be%20100s%20of%20hyperlinks%20in%201%20spreadsheet.%20I%20need%20the%20macro%20code%20to%20accomplish.%20I%20can%20opened%20the%20files%20but%20I%20do%20not%20yet%20a%20way%20to%20save%20these%20PDF%20files%20to%20the%20selected%20folder%20using%20the%20desired%20file%20name.%20The%20general%20steps%20are%3A%26nbsp%3B%3C%2FP%3E%3CP%3E1)%20Open%20Excel%26nbsp%3B%3C%2FP%3E%3CP%3E2)%20Click%20on%20hyperlink%20in%20field%20cell%20%22T2%22%20to%20open%20pdf%20file%20%22123456.PDF%22%2C%20after%26nbsp%3B%22123456.PDF%22%20is%20open%2C%26nbsp%3B%3C%2FP%3E%3CP%3E3)%20Save%26nbsp%3B%22123456.PDF%22%20to%20a%20selected%20folder%20c%3A%2Ffiles%2Fpdfs%2F%20and%20change%20the%20name%20of%26nbsp%3B%22123456.PDF%22%20to%20%22WI-123456.PDF%22%20resulting%20in%20newly%20named%20pdf%20in%20folder%26nbsp%3Bc%3A%2Ffiles%2Fpdfs%2FWI-123456.PDF%3C%2FP%3E%3CP%3E4)%20Go%20to%20cell%20%22T3%22%20and%20perform%20again%3C%2FP%3E%3CP%3E5)%26nbsp%3BGo%20to%20cell%20%22T4%22%20and%20perform%20again%3C%2FP%3E%3CP%3E6)%20Keep%20performing%20until%20there%20are%20no%20more%20rows%20of%20data%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2426563%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Regular Visitor

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  

0 Replies