Multiple Instances and excel

[HiArt99]

I think I know the answer to this, but I thought i'd check as someone once told me different.

I want to use excel to fire bets in to BA. But I have several different strategies going: one for footy, one for puppies, one for nags and one for tennis.

Now I could run all of these off a single workbook, but, I find they conflict in getting data and placing bets; one performs openMarket before the other has finished processing the data.

it would be nice if I could use use multiple instances of excel, each with their own instance of BA. However I don't believe this is possible. At the moment I run the different startegies on different (virtual) machines.

Therefore I am attempting to implement locks on the BA interface so only one strategy can access BA at a time. Not as easy as it sounds!

So, am i correct? One excel instance per one BA instance per machine?

Art

[GaryRussell]

You can run multiple BA instances each linked to a separate workbook or preferably one BA instance linked to separate workbooks running in separate instances of Excel. Just make sure the workbooks are closed before linking them and use the browse button on the Excel link popup to open the workbooks. You need a separate tab page in BA for each workbook.

[Shaun]

I am having an issue when running several different markets where each market has it's own workbook things seam to run slower the more i add, only need to run about 8.

can you explain what loading the workbooks like this will do for me.