Getting data from web by inputting form

Hi,

Please use code tags before the mods get you. Click edit post, select your code and hit the # sign

Fixed. Sorry about that, I am brand new to the board. I can see how code tags help.

You aren't going to be able to post data directly like that because of the type of data the webpage is expecting.

It's also worth noting that (I believe) that this problem can't be solved through use of XML Requests or WinHTTPRequests due to the type of re-directs the site uses in the case of the former and the fact that windows appends a utf type to the end of the content type when using the winhttp request.

I thin kthe only way of getting this working would be through the use of automating ie, which is possible. I'll have a look at that if I get chance, but it will be much slower than all the above methods (though it doesn't look like there's a lot of choice)

When you say automating ie do you mean via excel? Thanks!

Yes, it would be done something like the below, but like I said, it's slow ~15 seconds. The below may look like it's not running, but it is

Please Login or Register  to view this content.

---------- Post added at 10:55 AM ---------- Previous post was at 10:54 AM ----------

Id' be interested in seeing any solution which doesn't involve ie which posts the data directly to the site and returns the results