I believe there is an undocumented "special feature"(Bug) using the
Excel 2000 web query,
Please correct me if I am wrong,

The following query in IE works fine :

http://globefunddb.theglobeandmail.c...ASC&result_cnt
17&fr_param11=&fr_param12=&fr_param13=&fr_param14= &pi_universe=IGF_FUNDS&product_id=

but in the following module-same query No Cigar! What's up?

sub get_it
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://globefunddb.theglobeandmail.c...e&orig_order=D
SC&result_cnt=17&fr_param11=&fr_param12=&fr_param1 3=&fr_param14=&pi_universe=IGF_FUNDS&product_id=" ,
_
Destination:=Range("a1"))
.BackgroundQuery = True
.TablesOnlyFromHTML = True
.Refresh BackgroundQuery:=False
.SaveData = True
End With
end sub