Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Application.MemoryFree

Is there a way to determine absolutely how much memory an
operation requires to perform properly? - So that
Application.MemoryFree could be used to skip an operation
when memory is not sufficient. If not - what is the
usefulness of Application.MemoryFree?

TIA
Mike
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default Application.MemoryFree

As far as I know, there is no way to determine how much memory a
certain operation will utilize. Application.MemoryFree isn't a
very useful function. Its primary use, it seems to me, to be in
producing diagnostic dumps when something goes wrong.


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


"Mike Archer" wrote in
message ...
Is there a way to determine absolutely how much memory an
operation requires to perform properly? - So that
Application.MemoryFree could be used to skip an operation
when memory is not sufficient. If not - what is the
usefulness of Application.MemoryFree?

TIA
Mike



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
Application TullaOlsen Excel Discussion (Misc queries) 0 March 16th 06 07:57 PM
macro to close excel application other than application.quit mary Excel Programming 1 September 14th 04 03:43 PM
application.quit will not shut off application john Excel Programming 0 January 9th 04 11:29 PM
Getting Application.Sum to act like =SUM Mike Cooper Excel Programming 0 July 21st 03 10:26 PM
What's this? (Application.Run) Karl Thompson Excel Programming 1 July 10th 03 07:46 PM


All times are GMT +1. The time now is 05:44 AM.

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"