For the best only
For the best only
(OP)
I have a big excel file with a lot of macros.
This file is slow and the code is not too bad.
The interesting thing is that when we send Excel in background during an excel calculation (macro or other), for example if you active an explorer window, excel is "speedster".
Do you know the reson? Do you know if is possible to set this "excel status" with some computer settings?
This file is slow and the code is not too bad.
The interesting thing is that when we send Excel in background during an excel calculation (macro or other), for example if you active an explorer window, excel is "speedster".
Do you know the reson? Do you know if is possible to set this "excel status" with some computer settings?





RE: For the best only
See
ht
Katmar Software
Engineering & Risk Analysis Software
http://katmarsoftware.com
RE: For the best only
RE: For the best only
RE: For the best only
In any case, if you lock the calculation too (application.calculation=xlmanualcalculation) you can reduce more this lenght of time!
RE: For the best only
Are you sure there's not a badly coded loop in one of the macros?
How much RAM does your computer have? If you go to the Task Manager, is the processor maxed out?
RE: For the best only
The code is OK
I have 512Mb but this is the same on 2Gb computers.
The task manager is OK and in any case send excel in background doesn't change the processor status.