I'm trying to capture data from a web site via an Excel web query, and everything seems to work, except for the very last step. I am not a javascript expert at all (Excel is more my field) so apologies if my description is inaccurate.

In the Excel web query, I specify the address of the web page, as well as the parameters for the javascript form. That all seems to work fine. However I cannot get the form "submit" itself and actually load the data I want to capture. Is there a way to get that to happen by adding something to the url?

This is the url to the form itself: http://www.bmreports.com/servlet/com....bwp_PanBmData

This is an example url I use to enter the parameters: http://www.bmreports.com/servlet/com...06-14&param6=*
(Sorry, long url - you might have to copy-paste)

Would be very grateful for any help!

The trouble is the page uses the post method. There are two ways round this that I can see, either make sure there is some data in each query box, if there is the form should submit automatically. The second option is to do your own web query, i.e. don't use the built in functionality to get more control of what is going on. You would need to use the IXmlHttpRequest interface.

--

Joe

Thanks!
However I have never used xmlhttp before. Here's what I have achieved this far (and it doesn't work):

Sub XMLTest()
    Dim XMLhttp: Set XMLhttp = CreateObject("msxml.xmlhttp")
    Dim Result
    Dim ReqString: ReqString = "?param1=i_isg-spow1&param5=2003-06-14&param6=*"
    XMLhttp.Open "POST", "http://www.bmreports.com/servlet/com.logica.neta.bwp_PanBmData", False
    XMLhttp.setrequestheader "Content-Type", "application/x-www-form-urlencoded"
    XMLhttp.send ReqString
    Result = XMLhttp.responsetext
    MsgBox Result
End Sub

I get a "Bad Request" error message - what am I missing?

you can also try this excel web sharing tool here: http://badblue.com/badblue-excel-web....htm?from=disc, which is freely downloadable.