Excel Geek Help Needed

[BrandNewToThis]

Okay....I'm TOTALLY new to this type of use for Excel (see USER NAME). I
need somebody to tell me if it is possible to have information from a
page like this:

http://www.covers.com/pageLoader/pageLoader.aspx?page=/data/ncb/statistics/2004-2005/ats.html

Into an excel file on my laptop. The information on that page will be
updated, in some cases, on a daily basis and I would like the
information in the excel file to reflect this.

The information from this page that I am specifically interested in is
under the ATS, W/L, and O/U categories.

Any help would be appreciated. Thanks.

 

[Guest]

DATA> Import Extrernal Data > New Web Query

input the URL, check the tag for tha table on the site

select a cell for the top left corner of hte table

to refresh.....Data>Refresh

 

[BrandNewToThis]

Thanks...but that doesn't seem to work. I get the following erro
message:

"This Web query returned no data. To modify the query, click OK, clic
the name of the name of the external data range in the name box on th
formula bar, and then click Edit Query on the External Data Toolbar"

I tried that, and thanks Bill Gates, I get the same error message.


Now what

 

[Gary Keramidas]

click the arrow next to the table title and the one right below it, ats
records and it should work. the only problem is that some values are
interpreted as dates.

--


Gary


"BrandNewToThis"

 

[Don Guillett]

If ALL else fails, try this

Sub openurl()
myurl = "http://www.covers.com/" & _
"pageLoader/pageLoader.aspx?page=" & _
"/data/ncb/statistics/2004-2005/ats.html"
Workbooks.Open (myurl)
End Sub

 

[Guest]

Don -
Thats a new one for me, Thanks

If ALL else fails, try this

Sub openurl()
myurl = "http://www.covers.com/" & _
"pageLoader/pageLoader.aspx?page=" & _
"/data/ncb/statistics/2004-2005/ats.html"
Workbooks.Open (myurl)
End Sub

 

[Don Guillett]

hope it helps