how to do other things while excel runs my simulation

[Guest]

Hi,

My excel (VBA) simulation takes 6 hours to run. I need to do work while it
is running. Whenever I try to go to another application, when the simulation
runs, excel periodically places me back in its window. So lets say i'm typing
in Word, i'll get pulled into excel, and my typing wuld apper in excel (and
my simulation will crash...).

What to do?

 

[Guest]

Hi

1. Are you sure your code can't be optimized? 6 hours seems forever...

2. What exactly are you doing / using in the code? Do you use a lot of
Activate?

 

[Guest]

The code cant be optimized
No activates. No selects.

I figured out what the problem was. I use some 3rd party code that probably
does use those things. Argh.

Thans.

 

[Guest]

OK, thanks for letting us know.