CPU usage if excel is not in the Active Window
 

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

CPU usage if excel is not in the Active Window
 

Hi Paolo,

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

AppActivate ("Microsoft Excel")

--
Regards,

OssieMac

CPU usage if excel is not in the Active Window
 

ty bb !!!