how to do other things while excel runs my simulation
 

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?

how to do other things while excel runs my simulation
 

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?

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"vivmaha" wrote:

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?

how to do other things while excel runs my simulation
 

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.

"Wigi" wrote:

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?

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"vivmaha" wrote:

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?

how to do other things while excel runs my simulation
 

OK, thanks for letting us know.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"vivmaha" wrote:

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.

"Wigi" wrote:

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?

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"vivmaha" wrote:

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?