Hi folks. This is an area that I am not familiar with at all. I am
trying to query a web page from excl:

http://ets.powerpool.ab.ca/Market/Re...DReportServlet

What I want is to dump the data from the tables into Sheet1 cell A1. I
originally attempted to do this manually by going to Data/Import
Data/New Web Query. I put the address in the address window, clicked
the boxes next to the tables I wanted and hit Import. I get an error
message say the web query returned no data.

A colleague of mine told me that the reason it does not work is that
the HTML code has a line in it (line 3) that says:

<pThe report is downloading, please wait...</p

As such the query is failing due to this line of code. Firstly I need
to figure out why this is not working manually. Upon figuring that
out, I need to write VBA code which will undetake this task - updating
every 5 minutes. That is I want it to paste the desired table to the
same excel cell destination every 5 minutes.

Any help would be appreciated.

Thank-you


---
Message posted from http://www.ExcelForum.com/