Login to web-sights from Excel spreadsheet

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.

  • On my Excel spreadsheet: web address is in B, username in C, password in D, UN ID in E, PW ID in F, Button ID in G, land page (to go to after logged in) in H. Right click triggers below macro for that particular row. Succeeds in opening address in B, however not seeing log in credentials being put in and gives "Run-time error '5000': Application-defined or object-defined error" on following line:

    Set e = IE.document.getElementById(Range("G" & (ActiveCell.Row)))

    Here's my code - seems close, but no cigar:

Participate now!

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