Macro to access url's from an excel table and download pdfs

[sveninho]

Hi all,

I have this excel spreadsheet that has a table with a list of url's on column T. These URLs lead to a very simple page with the button "Download a Copy", which allows me to download a pdf doc.

I was wondering if it's possible to create a macro that goes into each cell with the URL, open the respective URL and download the pdf into a certain folder in my computer (bonus: also name the files using a certain logic inside the spreadsheet).

Thanks in advance for the support!

Cheers,
Sveninho

 

[Rijnsent]

Hi Sveninho,
yes, VBA can do that. I found a bunch of references if you look for e.g. "VBA excel download file". Some examples:
https://www.mrexcel.com/forum/excel-questions/353006-download-file-excel.html
https://www.mrexcel.com/forum/excel-questions/740193-vba-download-pdf-url.html
If you are stuck and have some code, please post it here with a more detailed question.
Cheers,
Koen