reload racing post tissue ; refresh balance

[Koksi]

Hi!
1. I have combined the "racing post tissue price capture example" with the "reload quick pick list at midnight" sheet but after the quick pick list is reloaded and the first market selected no tissue price is shown. The time it reloads is 10 am.

2. And I want to refresh the balance 40 seconds before the race begins.

Can somebody help me with that?

[Koksi]

*2. I have a column wich shows the seconds until the race begins.(AA2) I think it can be done with a "U" in the J2 column but i cannot write vba codes...

[2020vision]

Hi Koksi

You should be able to do this automatically in Options>Preferences>General tab
and set balance refresh rate?

Does this help? You may need the beta version installed though - see...
http://www.gruss-software.co.uk/forum/viewtopic.php?t=5721

Ttfn - Michael

P.S. Or did you ONLY want it refreshing at 40secs before the off - if so somebody else may help?

[Koksi]

Hi Michael!
Thanks for your help! I really had an older version but now it works fine
So the second problem is solved and I just need help solving the first.