Using VBA To Save Web Based PDF to My PC

faulconert

New Member
Joined
Sep 23, 2014
Messages
3
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.

[url]www.f5.com/pdf/white-papers/http-fundamentals-wp.pdf[/URL]
Thank you in advance for your time.

Tim


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

Threads
1,109,494
Messages
5,529,192
Members
409,857
Latest member
KailuaTown
Top