View Single Post
Old 10-10-2008   #2 (permalink)
mayayana


 
 

Re: How to print a web page with VBA?

I haven't tested this, but I think it should work:

obIe.ExecWB 6, 0

You should also make sure the page is fully loaded
before calling it:

Do Until obIe.ReadyState = 4
Loop
Quote:

> With VBA, I do something like the following:
>
> Set obIe = CreateObject("InternetExplorer.Application")
> obIe.navigate (URLaddress)
>
> The page loads, and now I want to print the page.
>
> I've tried:
> obIe.print
> me.print
> printer.print
> obIe.document.print
>
> and some others. Nothing I've tried works. Does anyone know the
> correct way to do this?
>
> Thank you in advance.

My System SpecsSystem Spec