Using a macro to open then print a webpage?

[pbroadmeadow]

Hello all! I am trying to use a macro in Excel to open a website (the URL is a named range in a worksheet) and then print the web page. I am able to open the webpage with the following code:

Sub View_Tech_Recalls()
Set ie = CreateObject("InternetExplorer.Application")
ie.navigate Range("Recall_URL")
ie.StatusBar = False
ie.Toolbar = True
ie.Visible = True
ie.Resizable = True
ie.AddressBar = False
End Sub

What do I need to add in order to print the open web page?

Thanks for your help!

Paul

 

[Macropod]

farhan08: Kindly don't resurrect long-since dormant threads just to hijack it with an unrelated question. Start a new thread instead. Thread closed.