trying to click webpage button with vba

[dfida]

Hi All...Happy New Year!

I've searched around and cannot seem to find a solution to this issue...I've been able to use VBA to fill in the login and password text boxes, but can't figure out how to click the button underneath them.
Using the code below, I get the following error message:

Run-time error 91:
Object variable or with block variable not set

Here is my code:

objIE.document.getelementbyid("login").Value = "123456"
objIE.document.getelementbyid("password").Value = "abcdefg"
objIE.document.getelementbyid("submit").Click

Here is the HTML for the submit button:

        ********>document.write("");*********>

Can anyone help? I'm sure I'm overlooking something obvious...








</PRE>

 

[Norie]

Is submit actually the id of the button?

Are the controls located on some sort of login form?

If they are you could try this.

objIE.document.forms(0).submit

PS I don't think the HTML has posted properly on the board.

 

[dfida]

Is submit actually the id of the button?

Are the controls located on some sort of login form?

If they are you could try this.

objIE.document.forms(0).submit

PS I don't think the HTML has posted properly on the board.

Norie, about the login form, I think you are right. Using the following code, I was able to click and login just fine:

objIE.document.LoginForm.Submit.Click

However, even after login, I get the following error message:

run-time error 438
object doesn't support this property or method

So, now that I am actually able to login, I just need to get past this latest error so that I can go to the next step, which is to navigate to a URL. Is there code I can use to just ignore the error? Or is there a better way?


As for the HTML code not posting correctly, it looked ok in the preview, but when I click "submit reply" it posts differently. So, sorry about that. I still have not been able to get it to post correctly....attached is an image.

 

[dfida]

Ok, I figured it out. All I had to do was omit that last "Click" from my VBA.

Thanks for your help!

 

[Norie]

There was no Click in the code I posted.

Don't think you can click a form, even if you can don't think it does much.

 

[dfida]

There was no Click in the code I posted.

Don't think you can click a form, even if you can don't think it does much.

Norie....when you're a beginner like me, you tend to overlook those little details

Thanks again for your help!