Memory usage

[Guest]

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.

 

[Guest]

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

 

[Guest]

Hi Frank,

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

Thank you for your answer.

 

[Vic Eldridge]

Hi Jac,

The following worksheet functions will probably help.

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


Regards,
Vic Eldridge

 

[Guest]

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.