Multiple Excel Advanced

[hurdl]

Ive posted this in a new topic as the post just below me doesn't apply to me i don't think.

Basically i have a very large excel vba script and i cover all meetings, all races, all day. If there are 3 meetings on, i will open 3 versions of BA, one for each. If i just click the shortcuts for my Excel sheets, the all open in one instance of Excel. This is no good to me as Excel cannot calculate everything i need in time and becomes very unresponsive. If i open multiple instances of Excel (go to start/run/excel.exe) so i have 3 Excel.exe running in task manager, this will solve my problem, however BA will only recognise the 1th open instance of excel.exe.

I am wondering how i can run all this so BA.exe (1) is linked with excel.exe (1), BA.exe (2) is linked with excel.exe (2) etc?

Many thank and apologies if i have mis understood the other post i just didnt think that was the same as what i am after

[hurdl]

I forgot to add, i know its not my computer that cannot process the excel calculations because the CPU is only at 33% with 39 races being monitored.

[GaryRussell]

I'd never thought of this being an issue before. You have made a very good point. I will look into this and get back to you asap.

[hurdl]

Thanks a lot Gary

[GaryRussell]

I have just uploaded a pre-release version which allows you to select the file name of the separate instance of Excel (you must have the workbook open first). After you have selected the file name the workbook and worksheet drop downs will be populated with the details from the file you selected.

You can download it using the following link.
http://www.gruss-software.co.uk/Betting ... _Beta1.msi (ver 1.1.0.63)

Please let me know if it works for you.

[KevinTHFC]

Wow, what great support - well done Gary
Kevin

[hurdl]

Thankyou kindly, as previously stated, great support.

Ill give it a good test tomrrow.

Thanks again