Retrieving spreadsheets after closing them before closing BA

Discuss anything related to using the program (eg. triggered betting tactics)

Moderator: 2020vision

Retrieving spreadsheets after closing them before closing BA

Postby Happy Harry » Wed Oct 04, 2017 3:35 am

There has long been an issue with Betting Assistant in that if you close active spreadsheet(s) before you close BA it can lock the sheet(s) in such a way that the information in the sheet including all collected results are not accessible. And Excel will not retrieve it properly or so it appears.

There is a solution to recover your sheets intact. Open the Sheet in Excel and it will open to a blank sheet. So 3 blank tabs just like a new sheet.

Do ----> View ------> Unhide

And it will retrieve the sheet information intact.

By the way if Gary or Mark have a nicer or easier fix than this then it would be really appreciated.

HH
Happy Harry
 
Posts: 113
Joined: Sun Mar 06, 2011 12:42 am

Re: Retrieving spreadsheets after closing them before closin

Postby StuT » Wed Oct 04, 2017 12:45 pm

What about if you Untick Log current prices on the BA market tab before closing Excel.
Won't that unlink the spreadsheet to BA so you can save it away without an issue.
StuT
 
Posts: 87
Joined: Sun Dec 06, 2015 9:58 pm

Re: Retrieving spreadsheets after closing them before closin

Postby Happy Harry » Wed Oct 04, 2017 12:53 pm

Yep you are right. If you unlink them one by one or close BA then there is no issue. But I have up to 20 sheets running and sometimes, occasionally, I forget to close BA first which is when they get locked. And stepping across 20 tabs unconnecting each sheet 1 by 1 is a PITA.

My way of doing it is to simply close BA and then close the sheets BUT if I forget then the sheets all get locked.
Happy Harry
 
Posts: 113
Joined: Sun Mar 06, 2011 12:42 am

Re: Retrieving spreadsheets after closing them before closin

Postby osknows » Wed Oct 04, 2017 2:00 pm

You could add this event to the ThisWorkbook class so that the workbook is saved before closing

Code: Select all
Private Sub Workbook_BeforeClose(Cancel As Boolean)
    ThisWorkbook.Save
End Sub


I haven't tested it with BA though.
User avatar
osknows
 
Posts: 946
Joined: Wed Jul 29, 2009 12:01 am


Return to Discussion

Who is online

Users browsing this forum: No registered users and 7 guests

Sports betting software from Gruss Software


The strength of Gruss Software is that it’s been designed by one of you, a frustrated sports punter, and then developed by listening to dozens of like-minded enthusiasts.

Gruss is owned and run by brothers Gary and Mark Russell. Gary discovered Betfair in 2004 and soon realised that using bespoke software to place bets was much more efficient than merely placing them through the website.

Gary built his own software and then enhanced its features after trialling it through other Betfair users and reacting to their improvement ideas, something that still happens today.

He started making a small monthly charge so he could work on it full-time and then recruited Mark to help develop the products and Gruss Software was born.

We think it’s the best of its kind and so do a lot of our customers. But you can never stand still in this game and we’ll continue to improve the software if any more great ideas emerge.