programmatically changing priority of running excel macro at runti

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi again,

Is it possible/how to change the priority level of a running macro within a
macro itself. For example, when doing file i/o which is intensive i would
like to lower it's priority so that it doesn't hog cpu. I won't have to
worry about the macro holding the file lock for too long because this will be
the only process accessing the file.

Thanks again.
Bing
 
You can't change the priority of Excel's macros.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Hi Chip,

Thanks for responding.

How about programmatically changing the priority level of the Excel parent
application within a macro? Does VBA offer such functionality?

Thankss
Bing
 
You must log in or register to reply here.

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

Similar Threads

Don't re-run macro for five seconds...? 8
Running macro operations in serial fashion 6
How to see worksheet changes while macro is running? 1
How to Run a Macro From WB1 in WB2 Against WB2 5
Can you set process priority for an exe? 19
WEIRD - Excel is Changing the name of my macro 1
Opening a list of Excel files and run a macro in each 17
VBA macro speed 3

Back
Top