Activate a specified Firefox browser tab that is already open

[MannStewart]

Hi

I have an existing code as follows that opens a new Firefox browser tab each time it's run, but it ends up opening too many repeated identical tabs on the browser.

I'm thinking it should be modified to just activate the already opened tab if that URL is already open, instead of needlessly opening a new tab of the same site every time. But I don't know how to with my limited VBA knowledge, so hoping if someone could kindly help me to.

Sub OpenFireFoxNewTab(url As String)

    Dim pathFireFox As String
    pathFireFox = "C:\Program Files (x86)\Mozilla Firefox\firefox.exe"
    If Dir(pathFireFox) = "" Then
     pathFireFox = "C:\Program Files\Mozilla Firefox\firefox.exe"
    End If
   
    Shell """" & pathFireFox & """" & " -new-tab " & url, vbHide
  
End Sub

This is the tab opener code:

Sub FireFox_TopUniv()

    OpenFireFoxNewTab "https://www.topuniversities.com/university-rankings/world-university-rankings/2024"
    
End Sub

Stewart

 

[Micron]

AFAIK, Firefox does not provide a COM object that allows you to interact with VBA. That's why people generally use IE for this instead. Otherwise, you're stuck with using hacks such as API's to get cursor positions and control the mouse, or SendKeys, neither of which is very reliable.