Close off the Day - how to .....

[Happy Harry]

Sorry if this has already been answered but I cant find it.

How does one close off the day. Force an update to the Excel Spreadsheet keeping the results without finding a later race that is not autoloaded and manually loading it.

So, to explain further. In my case I load all the Australian ThoroughBred races. They process, perfect. Except that the last race finishes and because there is not another race, the results of the last race are not posted to Excel. So, in order to finish the day, I have to look for a race later than my current time somewhere else in the world, anywhere else in the world, load it up and that forces the update and closure to the spreadsheet. There must be a "force load to now" button but I can not find it.

Thanks.

[Shaun]

In cell J3 it gives you the number of races in the pick list, or at least i think it does.

On the last race it will display the letter "L" indicating last race.

You could set up a macro to look for the letter "L" then have it place the letter "U" in cell J2 and "-6" in Q2 this will update the balance and also update the results sheet.

[Happy Harry]

Absolutely Perfect thanks.

I will need to look at what goes into J3 normally because I can perhaps trigger more end of the day goodness using that information as well - so just need to look at what is going in there during the day normally as I would not want it to be doing things prematurely.

HH

[Shaun]

I don't think that would matter because it works the same as if you selected the next race it is just like and update trigger cell, there are a lot of other things you can put in here, take a look at the help files in the excel section.