CPU usage if excel is not in the Active Window

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
 
O

OssieMac

Hi Paolo,

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

AppActivate ("Microsoft Excel")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top