I am having a similar problem. I am accessing a USA weather page to get wind information. Don't know much about querytables but the program I had last year worked great. They must of changed something because now I have to change the date every day where I didn't have to with the old address Here is the new URL
"URL;http://tidesandcurrents.noaa.gov/data_listing.shtml?bdate=20100819&edate=20100820&datum=0&unit=1&shift=d&stn=8539094%20Burlington,%20Delaware%20River,%20NJ&type=Meteorological%20Observations&format=View+Data&listing=1" _
, Destination:=Range("A5"))
Here is the URL where I didn't have to change the date every day
"URL;http://tidesonline.nos.noaa.gov/data_read.shtml?station_info=8539094+Burlington,+Delaware+River,+NJ+" _
, Destination:=Range("A1"))
Would appreciate any help on this would help