Connect to already running instance of Internet Explorer

[Tommeck37]

Hello,

Can anyone help me out with connecting to already running instance of internet explorer. I have tried many codes posted in this forum and many others but all the codes in fact opened a new instance of IE.

What I am trying to do is to automate web based application "SalesForce" to create certain tasks in it.
I need to have a macro that binds to already logged in application and manipulate it by clicking specific buttons and writing specific data from Excle spreadsheet into the application.

Thank you for any directions.

Tommeck37

 

[vaskov17]

In the VBA editor go to Tools -> References and make sure that 'Microsoft Scripting Runtime' and 'Microsoft Internet Controls' are checked. Then use the following code to go through the IE windows and find whichever one you need. Note that the code will consider every tab a separate IE object.

Sub connectIE()
    Dim sWindows As New ShellWindows
    Dim IE As InternetExplorer
    
    For Each IE In sWindows
        MsgBox IE.LocationName
    Next
End Sub

change the MsgBox line to whatever you need

 

[Tommeck37]

That's wonderful! thank you very very much