Hi,
I have not managed to come up with a solution either myself or by searching. i could very well be asking the wrong questions, of course.
i have a spread sheet which has a very complex simulaton in it. excel is not the ideal place for it, but it is not possible to port it wholesale to something more sensible. i have modified the code so that it is possible to run two copies of the spread sheet (in two seperate excel processes) at one time. Due to the dual core nature of the machine this has almost no overhead.
I have created a controlling spread sheet that is cabable of launching multiple copies of the simulation and starting the code executing. the problem is the controlling spread sheet always waits for the code to return before it continues, hence it would open two seperate versions of excel, start the first simulation executing and then wait until it completes before starting the next one. is there any way of starting a function in another work book without waiting for the execution to complete?
i hope this makes sense, if you need any further information, please let me know what would be useful.
just to clarify: i can launch two seperate excel processes from my initial vba code, i can also call a function in the launched code, but i can't start it without having to wait for it to complete execution. i tried adding code to the on open command, so that the code would execute as soon as the spread sheet was opened, however the 'open' event did not finish and return exectution to the calling sheet until the simulation had completed.
regards
Bookmarks