Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Monitor memory usage | Links and Linking in Excel | |||
Monitor memory usage | Excel Discussion (Misc queries) | |||
Obtain memory usage? | Excel Programming | |||
VBA & Excel memory usage | Excel Programming | |||
VBA & Solver Memory Usage | Excel Programming |