open market using com ?

[alrodopial]

Hi,
I need help here guys,
I want from excel to open/create a new sheet, open a new tab/market in ba using the bf's market id and com (id already stored ie in a cell), link the new market from ba into new sheet.
If possible, link the same market into cell ieA20 also (using com and id)
If possible, close the market tab in ba ( using com)

The goto:id may work but you have to manually link the sheet first (?)

Any ideas?

[alrodopial]

A small progress:
I open ie 5 tabs in ba, link them into 5 sheets in excel and then with the below:

Code: Select all

Dim WithEvents ba As BettingAssistantCom.ComClass
Sub ddddddd()
    If ba Is Nothing Then
        Set ba = New BettingAssistantCom.ComClass
        ba.tabIndex = 0
    End If
    ddd = ba.openMarket(112818210, 1)
End Sub


I open the market I want in the correct tab - tabIndex = ??? must be the correct number.
Markets are already linked into excel sheets so trigger betting is ok.

1. why do I have to set a variable to ba.openMarket and not just ba.openMarket ?
2. How can I open a market at cell A20?
3. Is there a way to close a market in ba using com? - no need for further data requests -

[alrodopial]

Ok, how do I call the macro I posted?

I want to call it from a normal module and

1. If I place it in an object module it can not be called (sub not defined)

2. If I place it in a normal module the ba can not be defined (user defined type can not be defined)