Getting full race name / title into Excel

[greenfingers]

I'd like to automate getting the full race name for each horse race (UK & IRE) into excel, instead of just the shorthand Betfair version. It could be obtained from sportlinglife or racingpost etc, whichever is easiest.

e.g. 5:10pm race today on Betfair is:
"Salis 11th Aug - 17:10 7f Hcap"
but it's full name on Sportinglife is
"17:10 Axminster Carpets Racing Excellence Apprentice Handicap (whips Shall Be Carried But Not Used) (3yo+, Class 5, 6f 212y, 12 runners)"

I don't know any html or whatever is needed to do this cross reference. Any pointers in the right direction would be much appreciated! Thanks.

[alrodopial]

http://uk-betting-tips.co.uk/showthread ... cle/page56

[greenfingers]

Thanks alrodopial, but I can't download the link as I need pro-membership or to have done 50 posts! what is the file? Does it have the code to automate the retrieval of full race names? - it seems to be updated daily whereas I'm hoping to write code that will fully automate the process of retrieving the names.

[alrodopial]

Sorry I forgot it.
It's a daily excel file with info about the races.
Today's info:
http://uk-betting-tips.co.uk/attachment ... 1281520955

But you need something else , the code for extracting the info.
Anyone has any idea what's the easiest source for scraping this info?

[alrodopial]

Allow me few days , I'll create something that will do what you need.
It's not so difficult from sportinglife.

[greenfingers]

Wow, thanks alrodopial! That would be really great, very many thanks.

[Steve Voltage]

Sorry I forgot it.
It's a daily excel file with info about the races.
Today's info:
http://uk-betting-tips.co.uk/attachment ... 1281520955

But you need something else , the code for extracting the info.
Anyone has any idea what's the easiest source for scraping this info?

I still cannot open this file. 50 posts or £12 to join

[alrodopial]

Sorry guys, here it is , for 11 Aug

http://www.filefactory.com/file/b2f889b ... 100811.zip

[Steve Voltage]

Sorry guys, here it is , for 11 Aug

http://www.filefactory.com/file/b2f889b ... 100811.zip

Wow thats some sheet. I have a lot to learn, thanks alrodapial

[alrodopial]

Here is a try:
http://rapidshare.com/files/412852264/R ... glife.xlsm
Macros must be enabled.
Have fun

[greenfingers]

alrodopial THANK YOU SO MUCH! That is exactly what I need.

I really appreciate you taking time out to do this for me (and hopefully others too), it is very generous. No only does it do the job well, it looks great and is idiot proof. Perfect for me!

Sorry for taking so long to respond, I've literally only just downloaded the sheet. For some reason the email from the forum to notify me of your reply got sent to spam so I didn't know.

[greenfingers]

alrodopial - the Sporting Life have gone and cocked it all up by changing the format of the racecards screen. I suppose 2 years was a good run though.............
Don't suppose you might have the time / inclination to rejig the code??!! Please!

[alrodopial]

Can you send me or post the original file?

[alrodopial]

Change the macro "GetINFO" with the below :

Code: Select all

Sub GetINFO()

    Set wsTemp = Sheets("temp")
    Set wsNames = Sheets("Names")
   
    ' Delete old data
    Set myQTs = wsTemp.QueryTables
    If myQTs.Count >= 1 Then
        For Each qt In myQTs
            qt.Delete
        Next
    End If
    wsTemp.Rows("1:10000").ClearContents
   
    ' SL url with race's info
    SLracesURL = "URL;" & "http://horses.sportinglife.com/Meetings/"
    ' Download SL race's info in sheet temp
    Set SLracesPAGE = wsTemp.QueryTables _
        .Add(Connection:=SLracesURL, _
        Destination:=wsTemp.Cells(1, 1))
    With SLracesPAGE
        .WebSelectionType = xlEntirePage
        .WebFormatting = xlWebFormattingNone
        '.WebSelectionType = xlSpecifiedTables
        '.WebTables = "6"
        .WebDisableDateRecognition = True
        .Refresh BackgroundQuery:=False
    End With
   
    'Call GetINFO1
   
End Sub

You will need to do some work manually until I change the file- it will take me some time -
Your data is in sheet "temp"

[greenfingers]

I really appreciate your help with this, many thanks.

I've PM'd you the link for the original file, not sure if you still need it though.

Cheers.