by KESIMKESIM » Mon Dec 04, 2023 4:30 pm
Hi,
I haven't been using Betting Assistant for a couple of weeks and logged on this morning and saw the upgrade happen. Unfortunately, when I tried to connect a spreadsheet an error was generated and the spreadsheet would not update with the horse race details
The error window that popped up stated "Run-time error 459, object or class does not support the set of events"
My code stopped running at the line "If ba Is Nothing then Set ba-New BettingAssistantCom.ComClass" which I believe was one of the standard lines that had to be incorporated in the code.
This spreadsheet & code has been happily doing its stuff for years, so I'm not sure what has happened.
In case of an update problem, I deleted Betting Assistant and installed a clean copy. I also checked that under Tools/Reference that the BettingAssistantCom reference was ticked just in case, but it still doesn't work.
Grateful if you could advise what the problem may be, so that I can get up and working again.
Many Thanks.