Follow, download, and rename hyperlinked files?

[robbyvegas]

Hi all,

I have a spreadsheet with 5 columns, the last column being a hyperlink to a PDF stored on the internet. I'd like to automatically download each PDF, and to rename the downloaded PDF to include the text in the first column. An example is attached.

Could someone please help me figure out how to do this?

Thanks,

Rob

[mrice]

Try this

Please Login or Register  to view this content.

Credit for the inspiration goes to http://www.mrexcel.com/forum/excel-q...te.htmlhttp://