![]() |
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.
|
No prob just so long as you share it with everyone
|
1 Attachment(s)
Updated, fixed a couple of issues and the date will change automatically for unitab. :)
the instructions still the same as above |
Mine crashed after running getrace3 said the internet web address does not exist
|
you said runall right, you cannot just run the getraces3 macro, you have to run the runall macro
|
1 Attachment(s)
Update, fixed some bugs that arose today. This will go on until they are all fixed
|
That is correct, i will try it again i think it has something to do with the link.
|
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
|
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
|
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.