Using VBA to input data into a web page

Good evening all.

I found this (example) code which should access Wikipedia in Internet Explorer), put some data in a box and press the search button. All works well until it tries to press the "Go" button. I suspect this may be old code and the button is no longer called "Go" but "searchButton".

Anyway, two problems; if I leave it at "Go", I get an error: Run-time error '424', Object required. I thought, ah, I can cope with this, and edited it to "searchButton". This stops the error message but doesn't input the search term, it goes to the Search page as if I have cleared the search term (Document Object Model) ... so that's the second problem.

Note: it requires references to Microsoft HTML Object Library and Microsoft Internet Controls.


I would be grateful if someone could help me make this example work so that I can then adapt it to do other things. Alternatively, if you can provide code that does the same thing but in a different way, that would make me very happy too. Or, even better, a solution that isn't dependent on IE at all, but can use the default browser ... but I guess that could be asking a lot.

Thanks in advance, TMS

Please Login or Register  to view this content.

There are several functions to support this worked example:

Please Login or Register  to view this content.

Trevor,

Im by no means a IE expert but just fooling around a little bit the the code I had the Idea of entering the search term then click the button then enter the search term again then click the button again. Well it worked go figure. Guess more of a work around then a solution. I used the searchButton intead of GO

Please Login or Register  to view this content.

Or even this works

Please Login or Register  to view this content.

Mmmm, thanks Mike. That must be opening up the search page, entering the search item and then clicking search. Not ideal but I guess it must be something to do with that page.

I'll have to try and find other examples

Cheers

@Norie: I explained that at the start of my explanation ...

I found this (example) code which should access Wikipedia in Internet Explorer), put some data in a box and press the search button. All works well until it tries to press the "Go" button. I suspect this may be old code and the button is no longer called "Go" but "searchButton".

Anyway, two problems; if I leave it at "Go", I get an error: Run-time error '424', Object required. I thought, ah, I can cope with this, and edited it to "searchButton". This stops the error message but doesn't input the search term, it goes to the Search page as if I have cleared the search term (Document Object Model) ... so that's the second problem.

Thanks guys, sorry it's taken me a little while to get back to you ... just started researching my family tree and got a little involved.

@Norie: thanks. Your solution seems to be quite effective. I'm just trying to work out why ... the end stage seems to be the same but clearly something is different.

@Kyle. thanks also. I probably need to spend some time dwelling on your solution (based on Leith Ross's sample workbook) as I suspect that is exactly the type of thing that I am going to want to do.

Cheers, TMS