View Single Post
  #4  
Old 1st May 2013, 08:35 PM
Puntz Puntz is offline
Member
 
Join Date: Jan 2012
Posts: 291
Default

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.
Reply With Quote