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



--
Don Guillett
SalesAid Software