Internet Explorer Username & Password

[rprosser]

Good morning,

I currently I have a macro that goes out to a website and logs in using the send keys but I would like to modify the macro to login using the username and password value in the source code instead of the send keys. However, I’m just starting to learn how to use VBA to communicate with Internet Explorer and I’m not sure how to do it.

Can someone please navigate to https://appraisalport.com/ and view the source code and let me know if you can come up with a way to post a value to the username and password field? If you can give me the base code, I should be able to figure out the rest.

Also, does anyone know of a good book that I can get to learn how to use VBA to communicate to Internet Explorer?


If you have any questions or need additional information, please let me know and I’ll respond right away.

Thanks,

Rick

 

[Norie]

Rick

Here's a start.

'https://www.appraisalport.com/
Sub Test()
    Set ie = CreateObject("InternetExplorer.application")
    ie.Visible = True
    ie.navigate ("https://www.appraisalport.com/")
    Do
        If ie.readyState = 4 Then
            Exit Do
        Else
            DoEvents
        End If
    Loop
    Set doc = ie.document.frames("header").document
    
    Set ctl = doc.getElementById("txtUserID")
    
    ctl.Value = "UserID"
    
    Set ctl = doc.getElementById("txtPassword")
    
    ctl.Value = "Password"
    
    doc.forms(0).submit

End Sub

 

[rprosser]

Thanks so much!

It worked perfect! Thanks so much for the quick response. One last question for you. Do you know of any good book so resources that would help me learn how to communicate to Internet Explorer using VBA?

Thanks again,

Rick

 

[Norie]

Rick

I don't know of any book.

But I've found this <a href="http://msdn.microsoft.com/library/default.asp?url=/workshop/author/dhtml/reference/dhtml_reference_entry.asp
">link</a> useful.

 

[rprosser]

You have been a great help! I sure appreciate you taking the time to answer my questions and providing the link.

Rick