Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how do you select an internet explorer tab using vba?

Status
Not open for further replies.

ChrisNome

IS-IT--Management
Mar 22, 2011
47
US
I've got a relatively simple question: how do you select an internet explorer tab using vba?

for instance

code:

For Each appWindow in appShell.Windows
If TypeName(appWindow.Document) = "HTMLDocument" Then
Set appie = appWindow
If appie.LocationURL = "desired url" Then
Exit For
End If
End If
Next


.. will set appie to an internet explorer application object that holds a tab that has that url, but it won't select the tab. How do you get that tab to be clicked using code?

 
Whenever I do internet stuff I always run the recorder and go to the website, open what is need and then stop the recorder. Once recorded it gets edited as required.
 
where's the recorder for internet explorer?

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top