Hello,

I would like to create a macro to open IE, navigate to a web page, print the page (3 copies) and close the browser. The folling code will navigate to the web page, but I can't figure out how to print the page. I believe I can close the browser with IEapp.quit Any help would be greatly appreciated.

Thanks

Oreg


Sub getgeolink()

Dim IeApp As InternetExplorer
Dim sURL As String
Dim IeDoc As Object
Dim i As Long

Set IeApp = New InternetExplorer

IeApp.Visible = True

sURL = "http://www.excelforum.com"

IeApp.navigate sURL

Do
Loop Until IeApp.ReadyState = READYSTATE_COMPLETE

Set IeApp = Nothing

End Sub