Hi,
I've been able to find examples of how to pull a list of applications
currently in Task Manager via the functions below. However, I also want to
track memory usage of the currently running Excel Application.

I've looked around and really can't find an example that works. Based on
the examples I've seen (such as those below), this should be pretty easy to
do.

So, if I have xlApp.hwnd, how can I get the current memory being used by it?

Thanks!
MikeZz


Public Declare Function GetWindowText Lib "user32" Alias "GetWindowTextA"
(ByVal hwnd As Long, ByVal lpString As String, ByVal cch As Long) As Long

Public Declare Function GetClassName Lib "user32" Alias "GetClassNameA"
(ByVal hwnd As Long, ByVal lpClassName As String, ByVal nMaxCount As Long) As
Long

http://www.decisionmodels.com/memlimitsb.htm
--
HTH...

Jim Thomlinson


"MikeZz" wrote:

> Hi,
> I've been able to find examples of how to pull a list of applications
> currently in Task Manager via the functions below. However, I also want to
> track memory usage of the currently running Excel Application.
>
> I've looked around and really can't find an example that works. Based on
> the examples I've seen (such as those below), this should be pretty easy to
> do.
>
> So, if I have xlApp.hwnd, how can I get the current memory being used by it?
>
> Thanks!
> MikeZz
>
>
> Public Declare Function GetWindowText Lib "user32" Alias "GetWindowTextA"
> (ByVal hwnd As Long, ByVal lpString As String, ByVal cch As Long) As Long
>
> Public Declare Function GetClassName Lib "user32" Alias "GetClassNameA"
> (ByVal hwnd As Long, ByVal lpClassName As String, ByVal nMaxCount As Long) As
> Long
>
>