Saddlecloth numbers in Excel

[yursaduian]

Hi Gary

I've been using your code without any problems for quite sometime now extracting Live Fractional and Decimal Odds and Saddlecloth Numbers from Sporting Life.

The saddlecloth numbers suddenly started returning an error on Thursday and have not worked since.

Have you any idea please?

Thanks

[GaryRussell]

What is the error that they are returning?

[yursaduian]

The cell where the saddlecloth number used to be is now "#VALUE!"

[yursaduian]

Sorry Gary

but maybe I should also add that everything comes through fine to my spreadsheet from BA until the figures from Sporting Life kick in (first show) thats when everything goes up the wall

Does this help?

[GaryRussell]

Is it possible to send me the spreadsheet as I cannot replicate this problem. You can send it to admin@gruss-software.co.uk

Alternatively you could use the built in option to export the saddlecloth number to Excel using the Beta version. See http://www.gruss-software.co.uk/forum/v ... php?t=3922 for download link. When you set up the link to Excel you have the option to select extra columns including the saddlecloth number.

[yursaduian]

Gary

I've updated to the latest version (not beta) and with a bit of tweeking in my spreadsheet, it seems to be working fine again so not really sure what went on.

Hey ho - we're up and running again and that's what matters

Thanks again for your help

Cheers!