Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
raj raj is offline
external usenet poster
 
Posts: 32
Default Obtain memory usage?

Hello,

I can of course capture the processing time of my
functions and subroutines.

But to add a further dimension to my benchmarking, is it
possible using VBA in Excel XP with Windows 2000 to also
capture the amount of memory a given function or
subroutine actually consumes during run time?

Apart from speed and module size, are there other criteria
that I should consider and measure to check the efficiency
of my code?

Given our budget, my resources are limited to using
conventional apps and VBA.

Your example code would be most appreciated. Thanks in
advance for your input.

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
XL 2007 memory usage Dave F Excel Discussion (Misc queries) 5 August 21st 06 01:01 AM
Monitor memory usage JL Links and Linking in Excel 1 May 16th 05 10:05 PM
Monitor memory usage JL Excel Discussion (Misc queries) 0 May 13th 05 04:15 PM
VBA & Excel memory usage Kevin Excel Programming 2 August 18th 03 02:32 AM
VBA & Solver Memory Usage Dana DeLouis[_5_] Excel Programming 1 July 13th 03 04:58 AM


All times are GMT +1. The time now is 10:40 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"