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.
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,629
Messages
5,838,454
Members
430,549
Latest member
jayjay2022

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top