OZmium Sports Betting and Horse Racing Forums

OZmium Sports Betting and Horse Racing Forums (http://forums.ozmium.com.au/index.php)
-   General Topics (http://forums.ozmium.com.au/forumdisplay.php?f=59)
-   -   Daily Race List ( Excel 2007 ) (http://forums.ozmium.com.au/showthread.php?t=23379)

Puntz 22nd February 2012 10:11 PM

1 Attachment(s)
Ok, this workbook has a trial auto-race list.
It's web query is from www.tab.com.au

It's on test for now and hopefully Shaun may trim it up a bit or anyone else.
Just press the blue STAR Macro Enabler
in BUTTON SHEET

Or you can check out the process using the F8 key.

I'll still post the daily race sheet till and including this Saturday.

Shaun 23rd February 2012 12:24 AM

1 Attachment(s)
Made a couple adjustments to import and auto start.

For auto start to work workbook needs to be open.

Puntz 24th February 2012 12:07 AM

1 Attachment(s)
Ok,

So we have a BASIC Auto-Race List, there will be more ongoing developments as time permits.
Ideas welcomed.

Shaun, noticed the added code, it's much quicker and cleaner. Thanks.

The Timer is ok, seen it before ages and ages ago, forgot.

This version had to have a tweak, cos it missed a row in Sheet 2.

That's it from me, I won't be posting a daily race list from now on except updated Auto versions on this thread.

Shaun 24th February 2012 08:13 AM

There is extra you can add to the time code so that if the worksheet is closed it will open run the macro save the sheet and close again.

Puntz 26th February 2012 09:59 AM

Minor Fixes
 
1 Attachment(s)
Some minor fixes noted today,
Deletes rows with Abandoned races in Sheet 2

Puntz 28th February 2012 08:39 AM

Update-Seperated Lists
 
1 Attachment(s)
It may seem trivial, but to the eye and making decisions with money, less clutter can be an advantage.
Therefore I thought, ( that's a problem, "I thought"!) separating the list so harness,grey and races have their own list.

All worked well and on time.


All times are GMT +10. The time now is 01:48 PM.

Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.