HTML to PDF using VBA


First of all a big thanks to PDFCreator. Life wouldn't have been so easy without it.

I have been trying to automate PDFCreator using VBA.

Can I automate the creation of PDF from HTML file opened in IE?

My search on the web gave me codes that work within Excel or Word but what I really want is that I will input a HTML file path to a VBA form and it should open, navigate the browser and print it to PDF.

I know how to control PDFCreator by VBA, but I am not sure how do I link IE to the PDFCreator printer.

Help is very much appreciated



Sorry my English, but where can I find examples of using PDFCreator with VBA, I need to convert a HTML file to PDF, and the generated file name and save location created by the routine ...

Thank you ...