MyBets

[johnnic]

Is it possible to automatically copy the information provided in MyBets to another worksheet before it disappears into the ether?

Thanks

[GaryRussell]

There are two ways the information can disappear: Different market selected or market settled. Which one are you referring to?

In either case there isn't an option in Betting Assistant to do this so it would require some VBA to copy the information and the VBA would probably require a different approach for either, ie. it could copy the information just before the market changes or it could copy the information after the market is suspended.

[johnnic]

Thanks Gary. I'm referring to the situation when a new mariet is automatically selected.

I guess from your response that there is not an existing VBA module that has been written for this purpose?

[GaryRussell]

Not by ourselves and I don't recall seeing anything posted previously. I recommend not letting BA automatically select the next market, instead use the -1 trigger so that you are in control of when it changes. You can then write some code to copy the bets before using -1. This way you can be sure you copy them before the market changes. If you try to detect it changing it will be too late to copy the bets.