VBA open Web page in new tab with Auto login

[gmmdinesh]

Hi Everyone

I have a couple of code for Auto login web pages and it all should be open in new Tab not New IE Window..
In this code i got Object error .. can any one help me to solve this.

Sub ssss()  
  Dim IE As Object
    With CreateObject("Shell.Application").Windows
        If .Count > 0 Then
          Set IE = .Item(0)
    Else
            Set IE = CreateObject("InternetExplorer.Application")
      IE.Visible = True
    End If
  Do Until Not IE.busy And IE.readyState = 4
        DoEvents
    Loop
    With IE
    .Navigate "https://mail.google.com" ' for Example
  .Document.getElementById("userNameInput").Value = Sheets("Portal").Range("C79").Value
    .Document.getElementById("passwordInput").Value = Sheets("Portal").Range("B20").Value
    .Document.getElementById("submitButton").Click
  


    End With




    Do Until Not IE.busy And IE.readyState = 4
        DoEvents
    Loop
    Set IE = Nothing
  
  End With
  
End Sub

Thanks in Advance.

 

[John_w]

Specify the flags argument with the Navigate method, like this:

Sub Test()
    Dim IE As Object, URL1 As String, URL2 As String, URL3 As String
    
    URL1 = "http://www.url1.com"
    URL2 = "http://www.url2.com"
    URL3 = "http://www.url3.com"
    Set IE = CreateObject("InternetExplorer.Application")
    With IE
        .Visible = True        
        .Navigate URL1, 0
        While .Busy Or .ReadyState <> 4: DoEvents: Wend
        .Navigate URL2, 2048&
        .Navigate URL3, 2048&
    End With
    
End Sub

2048 is the value of navOpenInNewTab- see https://msdn.microsoft.com/en-us/library/dd565688(v=vs.85).aspx. Note that Busy and ReadyState only apply to the first Navigate.

 

[gmmdinesh]

Hi John
Thanks for your reply....
Your code only open web pages...but i want it'll be open and login automatically, then open another page on new tab and login automatically.....



Thanks

 

[John_w]

My code just shows the basics for opening a new IE tab. You'll have to incorporate it into your code, which is specific to your sites.

 

[gmmdinesh]

Hi John
Sorry for delay.

I have incorporate my code with your code, it's working.but the problem is it's login only First URL....for Next URL getting

Object Not found

Error....



Thanks