Web button click

[Sean Thomas]

Hi,
just started playing about with vba and HTML.
Can someone give me a clue how to click the button Continue

Please Login or Register  to view this content.

Currently using this code which gets to the site and enters a registration, now all need to do is hit the blue continue button

Please Login or Register  to view this content.

[Leith Ross]

Hello Sean,

It is so nice to Sean spelled correctly. Anyway, to answer your question see the code below.

Please Login or Register  to view this content.

[Sean Thomas]

Thanks Leith,
I have managed to overcome that part now, but I click the button and then wait for the page to refresh, then try pulling the data from the scource code.
I have found the data on the new scource code, but I am having trouble with resetting the new page as the HTMLdocument.
It keeps searching the old htmldocument
this is my code for this part

Please Login or Register  to view this content.

cant seem to get it to work.
Also if I have IE open already it causes problems finding the right browser
I tried this

Please Login or Register  to view this content.

it works by checking each window, but only if I have the message boxes in use, when I comment them out it doesn't find the page.
is it because it is halting the code long enough for the page to refresh properly?
im rather stuck.
when this works I can then pull the inner text out.
appreciate any help you can give me.

[Leith Ross]

Hello Sean,

I suspect that the refreshed page is using a Frame object. The Frame is itself a separate HTML document embedded within the main document. Look through the main page's source code for any Frame or IFrame objects.

You can access the Frame's document object like this...

Please Login or Register  to view this content.

NOTE: The Frame object has a Name property that may be useful when looping through the Frames to find the frame you want.

You can now pull elements from frmDoc like you would with HTMLDoc.

[Sean Thomas]

Cheers Leith I shall give it a go

[Leith Ross]

Hello Sean,

Sometimes the Frame document is used as a place holder for the data. The server will update the Frame document by inserting code into and then executing the new page. If the site does this way, you will not be able to gain access to the new page. VBA will only allow you client side access. To see the updated Frame document, you would need server side access.

Sealbh ort!