Is it possible to monitor memory usage via vba? Basically,
when a certain percentage of memory is reached I would
like to show a message box asking the user to close some
applications.

Thank you

JL

There are three properties you could use, MemoryUsed, MemoryFree,
TotalMemory. Like so

Sub memory()
With Application
MsgBox "Total memory used: " & .MemoryUsed
MsgBox "Total memory free: " & .MemoryFree
MsgBox "Total memory: " & .MemoryTotal
End With
End Sub

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"JL" wrote in message
...
Is it possible to monitor memory usage via vba? Basically,
when a certain percentage of memory is reached I would
like to show a message box asking the user to close some
applications.

Thank you