Today's racing - Excel spreadsheet
Hi all - for anyone who uses this I had to update to get the courses coming through correctly. I think the source site keeps changing how the data is displayed.
Anyway, it works again. Am trying to see how to include an option to include the Irish and US cards if anyone is interested. Maybe the original author could help out with this?
Anyway, it works again. Am trying to see how to include an option to include the Irish and US cards if anyone is interested. Maybe the original author could help out with this?
You do not have the required permissions to view the files attached to this post.
-
- Posts: 211
- Joined: Thu Apr 16, 2009 11:28 am
Hi,
Just a question does the spreadsheet update automatically or does each person that accesses it have to update it individually.
As I found it yeserday got it to work but today no joy just woundered if it was somthing I was doing wrong, it is certainly useful.
Regards
LilGB
Just a question does the spreadsheet update automatically or does each person that accesses it have to update it individually.
As I found it yeserday got it to work but today no joy just woundered if it was somthing I was doing wrong, it is certainly useful.
Regards
LilGB
Seems to work ok for me in Excel 2010.
Although it needs a small fix.
Once updated, go to the 'Market' column and replace each 'Newton' with 'Newton Abbot'.
Please feel free to correct the code yourself and post up here.
Although it needs a small fix.
Once updated, go to the 'Market' column and replace each 'Newton' with 'Newton Abbot'.
Please feel free to correct the code yourself and post up here.
Cheers Tub,
I'm still not able to get as far as that,I have taken debug after clicking update & this is what it says;
End If
If ActiveCell = "" Then ActiveCell.Offset(1, 0).Select
Loop While Mid(ActiveCell.Value, 1, 3) <> "Use"
Exit Sub
errorhandler: MsgBox "There was a problem getting the odds, please try again"
End Sub
Any help appreciated
Ben
I'm still not able to get as far as that,I have taken debug after clicking update & this is what it says;
End If
If ActiveCell = "" Then ActiveCell.Offset(1, 0).Select
Loop While Mid(ActiveCell.Value, 1, 3) <> "Use"
Exit Sub
errorhandler: MsgBox "There was a problem getting the odds, please try again"
End Sub
Any help appreciated
Ben
How can I get first meeting data racing in this Excel spreadsheet without error? The data from http://horses.sportinglife.com/Meetings/ are inside spreadsheet 'RaceCard' (but cuted - first part named "Book" it is Wetherby without first race):
Parsing error maybe?
12:50 Book Raceday Hospitality On 01937 582035 Handicap Chase (4yo+, Class 4, 2m 6f 110y, 6 runners)
Book 13:20 Follow Wetherby Racecourse On Facebook 'national Hunt' Novices' Hurdle (4yo+, Class 4, 2m 110y, 18 runners) 13:20 4 18 2m 110y Hurdle
Book 13:50 Buy Tickets For Boxing Day at Wetherbyracing.co.uk Handicap Chase (4yo+, Class 3, 2m, 7 runners) 13:50 3 7 2m Chase
Book 14:25 Subscribe To Racing Uk Juvenile Maiden Hurdle (3yo, Class 5, 2m 110y, 9 runners) 14:25 5 9 2m 110y Hurdle
Book 15:00 Bramham Hall For Conferences & Banqueting Beginners' Chase (4yo+, Class 4, 3m 1f, 4 runners) 15:00 4 4 3m 1f Chase
Book 15:35 E.b.f./dbs Mares' Standard Open Nh Flat Race (qualifier) (4-6yo, Class 5, 2m 110y, 10 runners) 15:35 5 10 2m 110y NH Flat
image Chepstow Fast Cards
Chepstow 13:10 Betfair Racing Excellence Conditional Jockeys' Training Series Handicap Chase (4yo+, Class 5, 2m 3f 110y, 5 runners) 13:10 5 5 2m 3f 110y Chase
//
...
//
Naas 15:40 Become A Go Racing In Kildare Member (pro/am) Flat Race (5-7yo, 2m, 8 runners) 15:40 8
Parsing error maybe?
Last edited by maciek on Thu Nov 25, 2010 7:53 am, edited 1 time in total.