P
pls123
Goodmorning everybody!!
I have an analysis program in excel made of few main workbooks and a lot of
child workbooks...its over 300..
they are open during analysis time and the run a macro evry second..
the problem is that the excel window must be active (like when you click on
the bar of the window..!! ) , or the cpu usage raises for 20-25 costant...
to over 45 (closing the DDE application for data import )..
i tryed to select the options to optimize for background èprograms but it
doen't have any effect..
it is not a big problem thus i just need to click the window bar with a
mouse macro recorder !!!
so do you know if it is a known issue or you have any idea to avoid the
problem !??
or do you have a row of vbe to run for making excel active window ??
tx all
paolo
I have an analysis program in excel made of few main workbooks and a lot of
child workbooks...its over 300..
they are open during analysis time and the run a macro evry second..
the problem is that the excel window must be active (like when you click on
the bar of the window..!! ) , or the cpu usage raises for 20-25 costant...
to over 45 (closing the DDE application for data import )..
i tryed to select the options to optimize for background èprograms but it
doen't have any effect..
it is not a big problem thus i just need to click the window bar with a
mouse macro recorder !!!
so do you know if it is a known issue or you have any idea to avoid the
problem !??
or do you have a row of vbe to run for making excel active window ??
tx all
paolo