Login to web-sights from Excel spreadsheet

  • 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!