"TCook" wrote in message
...
I am building something that needs to grab a certain instance of MS Excel.
Unfortunately, "GetObject" randomly chooses an instance and, therefore, is
not appropriate / robust enough by itself. In pseudo code, what I need is
below:

For each pProcess in Processes
If instr(pProcess.Name, "Excel") 0 And pProcess.Visible = True
Then
Set MyAppInstance = pProcess.Instance

Exit For
End If
Next pProcess

This isn't really a kernel issue but as you posted here, and as you seem to
be after a process list, CreateToolhelp32Snapshot(), Process32First(), and
Process32Next() will get that for you. You can check the docs for the
ProcessEntry32 structure to see if it contains the data that you need.

Just by the way, the main window for the version of Excel I have installed
here has a window class name of "XLMAIN". If the class name is constant
across versions you could use EnumWindows() to list the windows and
GetClassName() to filter out Excel's.

Regards,
Will

Hey Will,

Thanks for the info. After obtaining the appropriate process, can I then
actually get the instance of the Excel app such that I can work with its
object model?

Regards,

Todd



"William DePalo [MVP VC++]" wrote in message
...
"TCook" wrote in message
...
I am building something that needs to grab a certain instance of MS
Excel. Unfortunately, "GetObject" randomly chooses an instance and,
therefore, is not appropriate / robust enough by itself. In pseudo code,
what I need is below:

For each pProcess in Processes
If instr(pProcess.Name, "Excel") 0 And pProcess.Visible = True
Then
Set MyAppInstance = pProcess.Instance

Exit For
End If
Next pProcess

This isn't really a kernel issue but as you posted here, and as you seem
to be after a process list, CreateToolhelp32Snapshot(), Process32First(),
and Process32Next() will get that for you. You can check the docs for the
ProcessEntry32 structure to see if it contains the data that you need.

Just by the way, the main window for the version of Excel I have installed
here has a window class name of "XLMAIN". If the class name is constant
across versions you could use EnumWindows() to list the windows and
GetClassName() to filter out Excel's.

Regards,
Will

Todd,

The MS Word object has a 'Tasks' collection that will let you isolate
visible instances of active Windows. It might be worth the trouble to
create a hidden instance of Word and get the list.

Steve


"TCook" wrote in message
...
Hey Will,

Thanks for the info. After obtaining the appropriate process, can I then
actually get the instance of the Excel app such that I can work with its
object model?

Regards,

Todd



"William DePalo [MVP VC++]" wrote in message
...
"TCook" wrote in message
...
I am building something that needs to grab a certain instance of MS
Excel. Unfortunately, "GetObject" randomly chooses an instance and,
therefore, is not appropriate / robust enough by itself. In pseudo
code, what I need is below:

For each pProcess in Processes
If instr(pProcess.Name, "Excel") 0 And pProcess.Visible = True
Then
Set MyAppInstance = pProcess.Instance

Exit For
End If
Next pProcess

This isn't really a kernel issue but as you posted here, and as you seem
to be after a process list, CreateToolhelp32Snapshot(), Process32First(),
and Process32Next() will get that for you. You can check the docs for the
ProcessEntry32 structure to see if it contains the data that you need.

Just by the way, the main window for the version of Excel I have
installed here has a window class name of "XLMAIN". If the class name is
constant across versions you could use EnumWindows() to list the windows
and GetClassName() to filter out Excel's.

Regards,
Will