1st May 2013, 07:35 PM
|
Member
|
|
Join Date: Jan 2012
Posts: 292
|
|
html still works, Open the tatts.som web page, go to your race or event, copy URL,
It's easier to have your Internet Explorer Home page set to open to let's say
http://tatts.com/racing/2013/5/1/raceday
In Excel
Record macro mode.
( I Use Ctrl V on keyboard to paste )
Paste to Web Query to Import, have a few goes to sort out what tables you want. And you have your web query code.
Tables I use to save you the trouble;
Quote:
.RefreshPeriod = 0
.WebSelectionType = xlSpecifiedTables
.WebFormatting = xlWebFormattingNone
.WebTables = "1,2,3,4,5,6,7,8,11,12,16"
.WebConsecutiveDelimitersAsOne = True
|
Nowhere does it seem to show xml, it's still html
How long will it last before they plug this hole ?
I don't know.
|