BettingAssistantCom.ComClass and sheet invisible

[Tradyann]

Hello,

When i write this line in worksheet "Sheet1_Result" :

Code: Select all

Dim ba As New BettingAssistantCom.ComClass
[quote]

This sheet disappear in the list of sheets when i want to log BA and excel.

 :?: [/quote]

[GaryRussell]

Did you add the reference to BettingAssistantCom?

1) In the VBA code editor select References from the Tools menu.

2) You should find BettingAssistantCom under available references. Tick it if not already ticked.

3) Select "Compile VBA project" from the Debug menu. This should not produce any errors. If it does then you will still have problems.

[Tradyann]

"BettingAssistantCom" was unticked indeed.

Thanks Gary!