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?

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?

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?

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?