4th February 2012, 10:55 AM
|
Member
|
|
Join Date: Jan 2012
Posts: 291
|
|
race lists 20120204
The tatts url to get a racelist is
in cell A1
2012/02/04/raceday
With Selection.QueryTable
.Connection = "URL;http://tatts.com/racing/" & Range("A1") & ".html"
Then there is a series of macro to get it to go to columns
For some reason it won't work when I try . & Range("A1") & ".xml"
|