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.
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.
