Open internet explorer, print the contents and close internet explorer

[Per9922]

Hello all,

I really ned the help from you! This is what I want to do:

1) Open internet explorer with a html file
2) Print the html file
3) Close the internet explorer

Or can I print the html file direct ?

I have manage to do set 1 with this code:

Dim objExplorer
Set objExplorer = CreateObject("InternetExplorer.Application")
objExplorer.Visible = True
objExplorer.ToolBar = False
objExplorer.StatusBar = False
objExplorer.Navigate "about:blank"
objExplorer.Document.Open

Please help!
Per

 

[jkspeed]

Hello Per,

Try this code.

Set oShell = CreateObject("Shell.Application")

Set oFile = oShell.NameSpace("Path of the folder where the your html is.").ParseName("Your html file name.")

oFile.InvokeVerb("Print")

-jkspeed

 

[Per9922]

Thanks jkspeed!

I will try it tomorrow. Do you know how to in landscape ?

 

[jkspeed]

Nope. Sorry.

 

[Per9922]

Thanks jkspeed is worked!!