Web Query Failure using url.CFM with xl97

[Don Guillett]

I use the following code in xp home xl2002 to get this info for a friend.
Works great in xl2002. But friend has xl97 and I get what is shown below
code. I have tried changing the .cfm to .csv. html, etc. Is there some Java
Script that must be enabled somewhere? I also tried making the url into a
..iqy. Also tried the open workbook, etc. Friend wants to track changes in
these results for a week which I have done, etc.
TIA

Sub Update()
myurl = "http://www.vegasinsider.com/u/odds/15minute/NFL_lines.cfm?s=1798"
With Worksheets("Data").QueryTables.Add( _
Connection:="URL;" & myurl, Destination:=Worksheets("Data").Cells(1,
1))
.BackgroundQuery = False
.TablesOnlyFromHTML = False
' .WebFormatting = xlWebFormattingNone
.RefreshStyle = xlOverwriteCells
.Refresh BackgroundQuery:=False
.SaveData = True
End With
'DeleteNames
'CollectData
End Sub


<script language="JavaScript1.2" type="text/javascript"
src="http://www.vegasinsider.com/include/menu_items.js"></script>

<script language="JavaScript1.2" type="text/javascript"
src="http://www.vegasinsider.com/include/pd.js"></script>





<script language="JavaScript" type="text/javascript">

var IE = (document.all) ? 1 : 0;

var DOM = (document.getElementById) ? 1 : 0;

var NS4 = (document.layers) ? 1 : 0;

var MAC = ((navigator.appVersion.indexOf("PPC") >0) ||
(navigator.appVersion.indexOf("Mac") >0)) ? 1 : 0

</script>

 

[KJTFS]

I am not sure XL97 had web queries in it. I haven't used it for a while
though.


Keith
www.kjtfs.com

 

[Don Guillett]

Sure it does. I use it all the time for stock market queries. You can use
the method I showed or make an .iqy file to do it that way. Just can't seem
to get this url to work in xl97.