| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA macro runs fine, but freezes if I try to do ANYTHING else whileit runs | Setting up and Configuration of Excel | |||
| excel simulation formula | Excel Worksheet Functions | |||
| How to use Monte Carlo Simulation in Excel? | Excel Discussion (Misc queries) | |||
| Creating Excel simulation in VBA | Excel Programming | |||
| can excel do Monte Carlo simulation? | Excel Discussion (Misc queries) | |||
Hybrid Mode
