Is it possible for a macro to log into a website

[Jackblack1]

Good Morning

Is it possible to set up a macro to log into a website with the username and password, and copy the information from the page it opens up to into an excel. I would give further information, but I want to find out if something like is possible.

Thanks

Jim

 

[Norie]

Jim

It could be possible using VBA.

To give further details can you give more information?

Sub test()
    Set ie = CreateObject("InternetExplorer.application")
    ie.Visible = True
    ie.navigate ("HTTPS://dwayinstalls.hns.com/forms/viewservice.jsp?id=" & ActiveCell)
    Do
            If ie.readyState = 4 Then
                ie.Visible = True
                Exit Do
        Else
            DoEvents
        End If
    Loop
    
    ie.document.forms(0).all("User").Value = "me"
    ie.document.forms(0).all("Password").Value = "mypasssword"
    ie.document.forms(0).submit
End Sub

 

[Jackblack1]

Hi Norie

Thanks for taking my post, I tried your code up to getting onto the website, it work perfect. For the username on the website, the cursor is the first thing flashing when you get to the site, its the first entry. The password is a little more tricky, if you tab it is the second entry possible to enter. The tricky part is I would need to set up a popup box to enter in the password because the user has a key coder that generates a new password every minute. This is the way it set up.

User Name:

SecurID®Password/Pin+ 6 digit code:

 

[Norie]

Jim

So what do you need help with?

The inputbox or enteringthe password on the web page?

 

[Jackblack1]

I need help to get the username to pop in the box and the popbox for the password, I used the code from the macro you gave me but this is first time I've done this so it didn't turn out to work.

 

[Norie]

Jim

Sorry I'm not following you.

Do you want code to get user input, then put that input onto the web page?

 

[Jackblack1]

Ok Norie, I got to pop the username and password, it's the popup box that populates the passwrd that I need.

 

[Jackblack1]

Sorry About that...It is the user input to the popup box that will insert the password in the field. Because the password changes each minute so there is no way to hard code it