Thread: Memory usage
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jac Tremblay[_3_] Jac Tremblay[_3_] is offline
external usenet poster
 
Posts: 30
Default Memory usage

Hi Vic,

Yes these worksheets functions are effectively helpful for a particular
mesure at a point in time but what I'm looking for is a report of many
readings across the time a macro process (an important and complicated
calculation) is run.

Thank you for your comment.

"Vic Eldridge" wrote:

Hi Jac,

The following worksheet functions will probably help.

=Info("totmem")
=Info("memavail")
=Info("memused")


Regards,
Vic Eldridge



Jac Tremblay wrote in message ...
Hi Frank,

I will check that out and come back with a comment.

Thank you for your answer.

"Frank Kabel" wrote:

Hi
you may take a look at the FastExcel addin (not free though):
www.decisionmodels.com

"Jac Tremblay" wrote:

Hi everyone,

I know that there are tools (software) that can profile VBA code, but is
there such a tool to monitor memory usage by an Excel application?

Thank you.
--
Jac Tremblay