How do I Print a Web Page as PDF using Hyperlink in Excel 2007?

[James312]

I'm using Excel 2007 and PDF Converter 6 Professional Software (Nuance). One of my Excel Columns is a list of 50+ Hyperlinks that go to external web site pages of online retailers. While I'm new to VBA, I've been able to write the necessary VBA code to loop through the 50+ Hyperlinks, download several fields (name of retailer, item name, price of item, etc.), import those fields directly into Excel, then loop to the next hyperlink on down the column. This macro works fine. MY CHALLENGE: I also need to save the actual web site page as a PDF file. I need assistance in writing CODE for a macro that will open a web page (based on a hyperlink in Excel), select a printer driver (PDF Converter is the printer driver), print that web page to a file with a unique name in a folder name I can designate, then finally close that web page. The looping part of the Code is complete. My PDF Converter Software allows me to come back later and assemble all these 1 page PDF files into one larger document.

I am able to create a PDF file of the web page manually using the PDF Converter Software (add-in to Excel) by simply selecting PRINT, then selecting 'PDF Converter' as my 'Printer Driver'. I've attempted to 'Record a Macro' & watch the Code being generated, but as I perform the manual key stokes in the newly opened window once the hyperlink is activated and the web page opens, no Code is generated. I've gone through dozens of FAQs on the Tek-Tips web site, but other FAQs are related to printing Excel worksheets as PDFs rather than following a hyperlink and printing the resulting open web page as a PDF file. Your expertise & kind assistance in suggesting VBA code to utilize... or ... thread to this specific topic ... or...other guidance would be sincerely appreciated.

 

[madonnac]

I found this code that will print google.com to pdf

http://stackoverflow.com/questions/8423300/html-to-pdf-through-vba-using-pdfcreator

As long as you can get the URL, then you should be able to plug the URL into this code, or code it as a function that takes a URL so you can loop through it for all the urls you want to print

 

[James312]

Thanks, madonnac, for the help! This CODE work properly and prints the designated web page as a PDF. I'm continuing to modify for my application as I also need to archive these PDF files for later reference.