Automating IE with VBA Macro

[LeCoquille]

Hi everyone,

I'm kind of a noob when it comes to VBA, although I have been experimenting with it for a while.

What I'm trying to do is automate a login, some button clicks and then fill in a form on the webpage.

Now, I managed to get the macro to login. However, after that, it needs to click a button, which won't work. Or actually, it does work, but only when I F8 through my code. When I run it all at once it gives me a 'runtime error 424, object required' .

At first I thought this was because the element was not loaded on the page yet (the page load takes a while) so I added:

Please Login or Register  to view this content.

This didn't work, so I added a fixed wait:

Please Login or Register  to view this content.

Didn't work either.

Anyone some ideas on how to fix this? Again, it does work when I 'F8' the code.

Please find below full code:

Please Login or Register  to view this content.

Unfortunately, I can't send html because it's a work related login page.

Any ideas would be much appreciated!

Best,

J.

[AB33]

Do While IE.readystate <> 4: DoEvents: Loop

So, there are two steps in to to log-in?
Does the button have a "Name or ID"?

[LeCoquille]

The login is fine. I can use the VBA to login. It bugs at this line:

Please Login or Register  to view this content.

[AB33]

If you log-in why do you need to click then? Is it to go in to next page?

pt1:r1:0:r1:0:r1:0:g11

Is it a valid ID? How and where do you get it?

[LeCoquille]

Thanks for your reply again.

It's just a button click on the page after the login. I can put in user id/pass and click the login.

Yes, it's valid. I got it from the html of the webpage and it's working when I F8 through the code.

[AB33]

If it is working through F8 it is because of time lag.
Does the log-in have a name or ID?

Please Login or Register  to view this content.