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
--
Oreg
------------------------------------------------------------------------
Oreg's Profile:
http://www.excelforum.com/member.php...fo&userid=9195
View this thread:
http://www.excelforum.com/showthread...hreadid=530357