Hello,

I'm trying to figure out if it is possible to create a marcro to:

Follow a hyperlink that is in my spreadsheet that goes to a pdf online, then save it to a specific folder lcoation on my harddrive, using a specific file name that is located in an adjacent cell.

For example: cell d2 contains a link that goes to a pdf file online: I would like to automatically open it, and then save it to C:\Users\Jones\Desktop\Indiana\PDFs, using a file name that is located in cell c2.

I have 2000 pdfs that I would like to do this for!

Any help would be greatly appreciated!

Thanks,
Charles