Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default vba running slower if i'm not looking at it?

I have two computers on my desk. I keep the second one for running
macros that take awhile.

I have a process that is running on the second machine, and if I
remote to it from my main machine, and sit and watch it run, it does
what it does about 1000 times per minute. If I shrink my remote
connection window and don't look at it for awhile, it runs about 100
times slower. What is going on here? I've also tried logging out and
leaving it running, with the same effect. Any help would be
appreciated. Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default vba running slower if i'm not looking at it?

I believe when you reduce it, it becomes a background task, which has less
resource allocated.

"festdaddy" wrote in message
...
I have two computers on my desk. I keep the second one for running
macros that take awhile.

I have a process that is running on the second machine, and if I
remote to it from my main machine, and sit and watch it run, it does
what it does about 1000 times per minute. If I shrink my remote
connection window and don't look at it for awhile, it runs about 100
times slower. What is going on here? I've also tried logging out and
leaving it running, with the same effect. Any help would be
appreciated. Thanks.


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default vba running slower if i'm not looking at it?

I thought that it might be something like that, but its a separate
machine. Does a remote machine "know" if you are looking at it or not?
Can changing the priority of the process help?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 Goal Seek Macro Running 7 times slower than Excel 2003 Thomas Shortt Excel Programming 0 September 15th 08 04:32 PM
macros making files slower and slower Raja Excel Discussion (Misc queries) 1 May 9th 08 12:26 AM
macros -enabled Workbook is getting slower and slower!! Raja Excel Programming 1 April 23rd 08 01:06 PM
Excel gets slower and slower.... Romuald[_3_] Excel Programming 3 July 7th 05 02:25 PM
Slower run with many sheets stefantem[_2_] Excel Programming 3 September 16th 04 02:17 PM


All times are GMT +1. The time now is 11:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"