app.Activate - 424 error

[Sherri726]

I have the following working, the link opens and the Internet Explorer window activates but I receive a runtime error 424 object required - Any suggestions.


Private Sub SchedNoSubItem_Click()

Application.FollowHyperlink (HyperlinkPart(Me.[tblURLs.URL]))
InternetExplorerApplication.Activate
InternetExplorerApplication.WindowState = 0 'wdWindowStateRestore

End Sub

 

[PHV]

Where is the InternetExplorerApplication object instantiated ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886