Web query doesn't work on a specific site

[J Laroche]

I'm trying to make a web query on the site
http://www.climate.weatheroffice.ec.gc.ca/climateData/dailydata_f.html?timef
rame=2&Prov=XX&StationID=5415
but I always get an error (Unable to open http://...). All pages from the
government of Canada (even the main one, http://canada.gc.ca/main_f.html)
return the same error, but I'm successful with my queries on all other sites
I tried.

Is there a known problem in Excel that could prevent it from opening sites
made in a certain way? Or put in other words, what does Excel do differently
than web browsers when retrieving a page?

JL
Mac OS X 10.3.7, Office v.X 10.1.6

 

[JE McGimpsey]

I'm trying to make a web query on the site
http://www.climate.weatheroffice.ec.gc.ca/climateData/dailydata_f.html?timef
rame=2&Prov=XX&StationID=5415
but I always get an error (Unable to open http://...). All pages from the
government of Canada (even the main one, http://canada.gc.ca/main_f.html)
return the same error, but I'm successful with my queries on all other sites
I tried.

Is there a known problem in Excel that could prevent it from opening sites
made in a certain way? Or put in other words, what does Excel do differently
than web browsers when retrieving a page?

I suspect it's a problem external to XL.

This query worked fine for me:

 

[JE McGimpsey]

Wrote too soon. I tried it again with XLv.X and got the error message
you report.

XL04 retrieves it every time...

I'll see if I can do some more investigation.

 

[Jim Gordon MVP]

Hi,

Excel version X with the 10.1.5 update or later will fail to perform
some web queries.

The only work-around I know of is to uninstall Excel, the re-install but
don't update to 10.1.5

-Jim

 

[J Laroche]

Thanks to JE and Gordon for their excellent and quick replies. So MS breaks
Excel and then tries to make us update? Sigh! I hope they will post a fixed
10.1.7, even though XL2004 is out, as they did for 10.1.6. Otherwise I'll
have to make my queries in Windows and bring the files over.

Eventually I'd like to make a Visual Basic program to load all weather pages
from the past 60 months into one Excel file.

JE, in the query files supplied by MS and the one you posted, there are
parameters after the four mandatory lines, but absolutely no support
document mentions them on MS's site. I suppose they are QueryTable
properties as they can be found in Visual Basic's object browser. If it's
so, then why does "AdjustColumnWidth = false" have no influence? Or is it
overridden by the Properties selection made (or defaulted) when running the
saved query?

JL
Mac OS X 10.3.7, Office v.X 10.1.6


Jim Gordon MVP wrote on 2004/12/26 14:54:

Hi,

Excel version X with the 10.1.5 update or later will fail to perform
some web queries.

The only work-around I know of is to uninstall Excel, the re-install but
don't update to 10.1.5

-Jim

JE McGimpsey wrote on 2004/12/26 13:24: