Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
CPU usage if excel is not in the Active Window
ty bb !!!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
refer to active window when more than one window open for a file | Excel Programming | |||
How to Operate the active Excel Window with VB6 | Excel Programming | |||
Excel 2000 macro runs v.slowly when Excel is not Active Window | Excel Programming | |||
preventing closure of active excel window | Excel Programming | |||
Changing Excel Icon in the Active Window | Excel Programming |