COM Interface and excel

[Graham]

I'm about to have a go at using the COM interface with excel, very new to it and a lot to learn so this may seem like a stupid question.

Is it only possible to have one tab connected in only one instance of BA enabled on one machine at once? I have tried linking to Gary's GetMarketDepthExample, and I can do so successfully in one tab in one instance of BA, but if I open a second instance of BA, i cannot connect to the COM interface.

Thanks, and apologies if I am being thick!

[GaryRussell]

It only works with one instance of BA, but you can have multiple tabs open.

So in our example you could create another worksheet and copy the code from the first worksheet. You will then need to add a further line of code to each worksheet to tell it which tab page in BA to communicate with.

You need to replace the following code

Code: Select all

        If ba Is Nothing Then
            Set ba = New BettingAssistantCom.ComClass
        End If


with

Code: Select all

        If ba Is Nothing Then
            Set ba = New BettingAssistantCom.ComClass
            ba.tabIndex = 0
        End If


tabIndex is zero based therefore the second tab page is 1 etc.

[Graham]

Thanks Gary, at least now I know what I am trying to do is possible. Whether or not I can implement it remains to be seen!

Regards,

Graham

[Graham]

It only works with one instance of BA, but you can have multiple tabs open.

So in our example you could create another worksheet and copy the code from the first worksheet. You will then need to add a further line of code to each worksheet to tell it which tab page in BA to communicate with.

You need to replace the following code

Code: Select all

        If ba Is Nothing Then
            Set ba = New BettingAssistantCom.ComClass
        End If


with

Code: Select all

        If ba Is Nothing Then
            Set ba = New BettingAssistantCom.ComClass
            ba.tabIndex = 0
        End If


tabIndex is zero based therefore the second tab page is 1 etc.

Sorry, another question, I can only get this to work if the same market is open in each tab, should it work with different markets?

Thanks

Graham

[GaryRussell]

It should work with different markets. If you send your spreadsheet to admin@gruss-software.co.uk I can take a look for you.

[Graham]

Thanks Gary, I don't have a working spreadsheet as I am still trying to get to grips with the COM interface and what I can do with it. All I have done is used two copies of your getmarketdepth example, and inserted The following in the first copy
        If ba Is Nothing Then
            Set ba = New BettingAssistantCom.ComClass
            ba.tabIndex = 0
        End If

And in the second copy:

Code:
        If ba Is Nothing Then
            Set ba = New BettingAssistantCom.ComClass
            ba.tabIndex = 1
        End If

Then used the multiple sheets quick link.

The first tab links correctly, but unfortunately the second tab only links when the first tab has the same market.

Hope that makes sense, I am happy to forward you the log in details of a server with this set up if it's any help.

Thanks again,

Graham