Memory usage
 

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

Memory usage
 

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

Memory usage
 

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

Memory usage
 

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

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