Running two vba macros in parallel

Hi all,

I have two vbscript scripts spawning the same vba macro from different logons on a windows server 2003. Both Excel macros are similar, both reside in different directories, but require two different datasets (tables in Oracle DB). Both scripts are scheduled from the task manager. When scheduled in series, they run ok, both run about 2 hours (so 4 hours in total). When they are scheduled more or less in parallel (the second starts about 10 minutes later). The first finishes but the second gets stuck, and never resumes. Can vba macros be run in this fashion? It seems not.

Thanks for any tips.

Milos

Hi Roy,

The macros have the same code but are in two different workbooks and the workbooks are in two different directories. I've tried to seperate them as much as possible.

Milos

RoyUK,

I think I am not explaining myself properly. I have one macro copied into two locations on the hard disk. I have two accounts and I want to run this macro from these two accounts. It is the same macro, but I want to run it from two different accounts from two different locations. The only difference is that they access different data in the database. These macros generate about 10000 charts daily and work fine when not run in parallel. They compare weather data for 800 station for seven days ahead and that is why they run so long. There is nothing strange about that. I just want to parallelise the processes, because I want add more macros. I could run them in virtual machines but I don't want to go down that road just yet.
Thanks for your help so far.
Milos

Milos

Have you tried running them is separate instances of Excel? There is only one thread allocated for VBA in each instance.