Error 438 When trying to log onto Website with VBA

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • I am trying to automate the scraping of data from a particular website within an intranet. Step one of the code is simply getting VBA to Log on for me with my credentials.

    I changed the url (and username/password accordingly), to see if it was the code or the website and the code logs me in just fine.

    Also, the code displays the webpage for debugging purposes, and it seems as the username and password don't show up in the text boxes, but if I use my mouse to click on the username/password box, both boxes are filled in with my correct username and password as programmed in the code. When I run this macro i get the error "Run time error 438: Object doesn't support this property or method." The problem occurs in the highlighted portions below, Here is my code:

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!