Runtime Error '424' Object Required

Hey guys,
I'm very new to VBA, but i'm having trouble with this. I'm attemping to have excel run internet explorer, open a certain website and log me in using my org id, user id & password. here's the website... https://www.mersonline.org/mers/security/logonframe.htm. the problem i run in to is a Runtime Error 424 Object Required. can someone have a look and see if they can't solve this? also i'm just using a standard untouched excel workbook. named Book1, using Sheet1 if needed. Also, if possible, would like to have a hyperlink to the website/macro that would run this by clicking it, thanks!

Please Login or Register  to view this content.

When you create the object with the set statement you name it "oIE", but later you are referring to it as "IE".
You should alter the lines with "IE.xx" to "oIE.xxxx".

thanks tsjallie for the quick response! i did as you said and now it's giving me a "runtime error 91 object variable or with block variable not set" message. again im new to this so i thank you for your patience, i'm going to guess its somewhere after the "Do" command because it seems to load the website up until i need it to log me in. i've taken out the password info and replaced with xxxxxx, as that's the one thing i know for sure, and it can get me in some trouble putting it out there. Also is there a way to create a hyperlink out of this to sheet1 (any cell) that would run this rule when the hyperlink is clicked? thanks for the help!

Please Login or Register  to view this content.

Getting the same error.
Entered DIM oIE as object: same error
Deleted the END at line 18: same error

I really don't see what's wrong. Googling always shows roughly the same approach.
Hope some guru is watching this and comes up with a solution.

i've done some searching and actually found some code that works, when you debug it however im not sure how to pair it with opening internet explorer and running it altogether. it only works when i already have the website open.

Please Login or Register  to view this content.

Sendkeys did cross my mind, but it's a very rude method and in my opinion not suitable for a permanent solution.
You must realize that the keystrokes are sent to the window which has focus. That is why you can't test it from VB-editor.
You will have to run it as a macro from you excel sheet.

Try this macro:

Please Login or Register  to view this content.

By the way, I think the problem with other error comes from some missing library. I only don't which one.
Tbc

awesome, works perfectly. if i were to want to use this for adding say whatever is in cell A1 to this website would that just be "($A$1)" in place of orig id/user/pass? in other words there is a hyperlink within this website that i would like to get to (could be accomplished by hitting enter, then tab 15 times, then enter again) and then i would select a field within that hyperlinked screen (again could be accomplished this time by hitting enter, tab 12 times, add cell A1 then enter again) and paste info from cell A1. thanks a ton for all the help!

Yes, you can. Try this one.

Finally managed to solve the problem!
The elements we are looking for are in a frame. As a matter of fact in the second frame on the page.
Here is the sheet that workes properly (so, not uses sendkeys) and read the credentials from cells in a worksheet.