Using VBA To Save Web Based PDF to My PC


New Member
Sep 23, 2014
Hello everyone,

Long time lurker, first time poster here. The solutions I have found on this board have saved me countless hours in the past so thank you!

When you click on the below link it opens a PDF. Is it possible to use VBA in Excel 2010 to save that PDF to my PC? Maybe save it as NewFile.pdf on the Desktop.

Thank you in advance for your time.


Background (if you care to read):
A few times a month I have to save about 35 web based PDFs to my PC. Currently, the 35 links are saved in an excel file. I click on each and that opens each PDF. Once the PDF is open I just manually save it to the appropriate folder on my computer. What I am imagining is a macro that loops through all the links and saves the PDFs to the folder for me. I can write a loop but I dont even know where to begin when writing the code to save the PDF to my PC. That is way beyond my skill level.

The links I use are to my companys intranet so they wouldnt work if someone here clicked on them, but above is an example of a similar link to a PDF. When you click on the link below a PDF is opened. If someone can help me with the code to essentially automate the saving of this one PDF I think I can apply it to my loop macro.

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Watch MrExcel Video

Forum statistics

Latest member