com problem

[alrodopial]

one ba instance with tree tabs, each connected to diff excel file through log multiple sheets quick link - com enabled -

Two first two tabs/excel files work ok ( ba.tabIndex = 0 and ba.tabIndex = 1)
but when the first race in the third tab is connected i get the below error in the third excel file:

object or class does not support the set of events
at line:
Set ba = New BettingAssistantCom.ComClass

I remember that I added the third tab/excel file a day after the creation of the profile.

[GaryRussell]

It might be that you installed a BA update recently with changes to the COM dll. Excel doesn't like this. Try deleting the line where the ba object is declared (Dim statement) and re-enter it then compile the vba project from the debug menu.