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.

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________

No prob just so long as you share it with everyone

Updated, fixed a couple of issues and the date will change automatically for unitab.

the instructions still the same as above

Attached Files

Kwikpix Redux.xls (787.5 KB, 1163 views)

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

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________

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

Update, fixed some bugs that arose today. This will go on until they are all fixed

Attached Files

Kwikpix Redux.xls (818.0 KB, 1013 views)

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

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________

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

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

Attached Files

Kwikpix Redux (1) test.xls (859.0 KB, 1033 views)

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________

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