programmatically changing priority of running excel macro at runti
 

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

programmatically changing priority of running excel macro at runti
 

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


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


"Bing" wrote in message
...
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

programmatically changing priority of running excel macro at r
 

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

"Chip Pearson" wrote:

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


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


"Bing" wrote in message
...
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

programmatically changing priority of running excel macro at r
 

I don't believe this is possible.


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


"Bing" wrote in message
...
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

"Chip Pearson" wrote:

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


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


"Bing" wrote in message
...
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