CPU usage if excel is not in the Active Window

[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

 

[OssieMac]

Hi Paolo,

For this question "do you have a row of vbe to run for making excel active
window ??"

AppActivate ("Microsoft Excel")

 

[paolo luigi spinelli]

ty bb !!!