| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Priority (with macro??) | Excel Worksheet Functions | |||
| Changing DSN programmatically? | Excel Programming | |||
| Running macro when changing data | Excel Programming | |||
| changing an palette index value programmatically in Excel | Excel Programming | |||
| Auto_Open vs Open and call macro --priority question | Excel Programming | |||
Linear Mode
