Input Username & Password from Cell A1 & A2 on website

[Bipin619]

Sub test()
' open IE, navigate to the desired page and loop until fully loaded
    Set IE = CreateObject("InternetExplorer.Application")
    my_url = "https://services.gst.gov.in/services/login"

    With IE
        .Visible = True
        .Navigate my_url
        .Top = 50
        .Left = 530
        .Height = 400
        .Width = 400

    Do Until Not IE.Busy And IE.readyState = 4
        DoEvents
    Loop

    End With

' Input the username and password
    IE.Document.getElementById("user_name").Value = "testID" 
    IE.Document.getElementById("user_pass").Value = "testPW"

    Do Until Not IE.Busy And IE.readyState = 4
        DoEvents
    Loop
End Sub

I want text of cell A1 and Cell A2 instead of predefined name.

 

[Ajesh]

Not worked with IE but this should work. Adjust sheet name as per your need:

IE.Document.getElementById("user_name").Value = ThisWorkbook.Sheets("Sheet1").Range("A1").Value
IE.Document.getElementById("user_pass").Value = ThisWorkbook.Sheets("Sheet1").Range("A2).Value

BR/Ajesh

 

[Ajesh]

I tried Google and i guess this might help.

https://stackoverflow.com/questions/17040530/getelementbyid-via-msexcel-vba-object-required-424

You still need to pass the uname and password as I mentioned above.

 

[Bipin619]

It's not working. It says 'syntax error' marking second line red.