Close Browser Tab with VB
Is there a way to close an IE browser tab with VB? I've searched for hours and feel I'm missing something simple.
Here's the basic idea:
I'm importing data into Excel from web pages that also have links to pages that contain additional (detail) data. I open IE and navigate to a page, find the link, open a second tab... but after I access that second tab, I need to close it.
Here's some of the code I'm using -- everything works as expected until I need to close the second tab:
Code:
Sub MainProcess()
' Note that I have enabled references to the Microsoft HTML Object Library and Microsoft Internet Controls
Dim IE As SHDocVw.InternetExplorer
IE.Navigate URL
' some code to get the first batch of data I need and find the links to the additional data
wbOpenNewTab detailLink ' where detailLink is defined above
End Sub
Private Sub wbOpenNewTab(URL)
IE.Navigate2 URL, 1
' This is where I copy the data I need
IE.Quit ' This incorrectly closes the first tab, not the one I just opened
End Sub
Any help is appreciated.
Re: Close Browser Tab with VB
it would be possible to loop through the shell windows, to find the appropriate one, based on some criteria (eg. the url), and close it