Can you use vba to log on to a website?

[June7]

I have done it.

Did you test that code? Looks good, if you still have IE installed.

If you know element names, code can be much simpler.

Sample from my db:

        'open ASTM/AASHTO test standards website and pass agency username/password to the web page
        Dim oBrowser As InternetExplorer
        Set oBrowser = New InternetExplorer
        oBrowser.Silent = True
        oBrowser.Navigate "https://login.ihserc.com/login/erc?"
        oBrowser.Visible = True
        Do
            'Wait till the Browser is loaded
        Loop Until oBrowser.ReadyState = READYSTATE_COMPLETE
        oBrowser.Document.all.Item("subAcctLoginName").Value = "username"
        oBrowser.Document.all.Item("subAcctPassword").Value = "password"
        oBrowser.Document.all.Item("Submit").Click

Might find this of interest https://learn.microsoft.com/en-us/an...ge-through-vba