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)
-   -   download unitab horse data into excel spreadsheet - problem (http://forums.ozmium.com.au/showthread.php?t=20306)

Shaun 11th November 2010 04:11 PM

I see you are using the same form as i do for my ratings when i use them, i manually import each race as needed but have always wanted to automate the task so i might be able to steal some of your code if that's ok to get mine running.

kennedy22384 11th November 2010 04:11 PM

No prob just so long as you share it with everyone

kennedy22384 12th November 2010 09:45 AM

1 Attachment(s)
Updated, fixed a couple of issues and the date will change automatically for unitab. :)

the instructions still the same as above

Shaun 12th November 2010 10:00 AM

Mine crashed after running getrace3 said the internet web address does not exist

kennedy22384 12th November 2010 10:01 AM

you said runall right, you cannot just run the getraces3 macro, you have to run the runall macro

kennedy22384 12th November 2010 10:19 AM

1 Attachment(s)
Update, fixed some bugs that arose today. This will go on until they are all fixed

Shaun 12th November 2010 10:21 AM

That is correct, i will try it again i think it has something to do with the link.

kennedy22384 12th November 2010 10:25 AM

Another update on the way, just testing it and added code to delete the queries after each race. You may have noticed that the file size is increasing, that is due to the queries being held. i added code to take care of that. Will upload in about 20 mins or maybe less

Shaun 12th November 2010 10:33 AM

1 Attachment(s)
I uploaded the sheet as it is after i get the error, if you have a look on Racelists you will see under the date column it has replaced the date, i use win7 with office 2010

kennedy22384 12th November 2010 10:37 AM

It shouldnt have cause if you select a cell, it should say '2010-11-12
The single quotation mark makes sure it puts it in as the text and not the date


All times are GMT +10. The time now is 11:43 AM.

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