VBA to automate pdf process (from html)

[yippie_ky_yay]

Hello Forum,

There is a certain web page I need to periodically pdf. Rather than me open it up (always the same web address), select distiller, save as the same old filename - could I use vba to automate this process?

(I know it sounds lazy - but there is a perfectly good reason why I would need something like this).

Any help would be greatly appreciated!

-Sean

 

[Fizzio]

It should not be a problem if Distiller (I'm assuming that that is the HTML -> PDF creator) accepts command line arguments.
Look up the shell function in help.

 

[yippie_ky_yay]

Hey Fizzio - thanks for answering! The Shell function is where I started as well.

Distiller kinda works by taking over the print driver. So if you were in a webpage for example, you print the page but you select Distiller instead of your printer. You will then be prompted for a file name/path.

So far, the best I can think of, is using a label with a hyperlink to open the right page. If I could add something to the onclick event to print that page, and save as the proper path/filename then that would be great!

-Sean

 

[Fizzio]

Heres some code to select a different printer ie Distiller.

Here's a link to setting Distiller parameters and a link to the API reference including using VB call Distiller - may be useful.

 

[yippie_ky_yay]

This is interesting, but I do not think that I can use this. I need to be able to open a certain webpage (using Explorer), select a printer and print that.

Even forgetting the pdf part for now - do you know how I could just open and print a webpage?

Thanks again!

-Sean

**EDITED** saw your edit after I posted - I'll read through this tonight and get back to everyone - Thanks!

 

[yippie_ky_yay]

Here is something I found from mstrmage1768 at Tek-tips. It works beautifully for reports (just need to learn how to tweak it for my use).
http://www.tek-tips.com/faqs.cfm?spid=703&sfid=2533&newpid=703

-Sean