Quote:
>
> here is a VBScript (tested) that print a Web page.
>
> I think it will also work in VBA.
>
Your link seems to go around in circles, and it's basically
the same code I already posted.
The code, so people don't have to track it down:
On Error Resume Next
Const OLECMDID_PRINT = 6
Const OLECMDEXECOPT_DONTPROMPTUSER = 2
Const PRINT_WAITFORCOMPLETION = 2
Dim oIExplorer : Set oIExplorer =
CreateObject("InternetExplorer.Application")
oIExplorer.Navigate "http://www.scriptbox.at.tt/"
oIExplorer.Visible = 1
Do while oIExplorer.ReadyState <> 4
wscript.sleep 1000
Loop
oIExplorer.ExecWB OLECMDID_PRINT, OLECMDEXECOPT_DONTPROMPTUSER
--------------
Or for anyone who wants to get the actual file, the
real download link is here:
http://www.boris-toll.at/scriptbox/d...d%20print%20a%
20Web%20Page.vbs&filename=Open%20and%20print%20a%20Web%20Page.vbs