query table returning no data

Hi,

For my first post: I have been learning VB programming on my own using Excel and so far have managed with forum searches which have helped a lot. I have a sticky problem which I've not found a solution for so far, so hoping that this post will find someone who knows the answer.

I have a button that fires a macro, and all it does is create a query table through connecting to a cgi script, passing in variables to the command itself:

Please Login or Register  to view this content.

Initially when this shows up on my newly added sheet, Excel displays an error message "no data was returned by this web query". However, if I then select Edit Query... the page shows up fine, I can select the table I want, and it shows up on my worksheet. Refreshing the data with various parameters without exiting Excel works great. However, if I close down Excel and restart, then my query again returns "no data" and I have to do the MB3->Edit Query... all over again.

I have tried going the Perl script route - where I dynamically create an .iqy file from which the query then tries to execute but still the same problem (and now this is worse because I can't overwrite the .iqy file once the connection has been made - is there a way to disconnect programmatically?).

Anyway, hope someone has some ideas on what can be done so the initial "no data" message is not encountered. I appreciate any help from anyone out there!

I got this eventually sorted out by using an IE query and then asking for the html data from the webpage. Hope this helps someone else out there that might be having a similar challenge:

Please Login or Register  to view this content.