Hi,
I regularly run lengthy macros on excel 2007(that take about 20 hours at
a time). However, I have found that when I open a new excel application on
the same computer(I have a dual processor pentium with 2 gigs of ram) - with
the intention of developing new macros on completely new sheets - then the
macro I was originally running gets hung up and never finishes.
When I run the original macro, it is only using one processor.
So, is it possible for me to open a second excel application that
specifically uses the idle processor, without disturbing the original macro
which is running on the original processor? That way, I can develop new
macros while the old runs are running. (as it stands now, I can not run
macros and develop at the same time)