Switching between excel applications

W

wbl

Hi,

How can switch from excel application (instance) with VBA ?

I want to view all open workbooks in multiple running excel
applications.

With GetClassName and GetWindowThreadProcessId is it possible to view
the classname and procecessID's from the multiple running Excel
applications.
But how can I activate a other Excel application to view the open
workbooks ?

Regards,
wbl:confused:
 
D

Dave Peterson

First, I have no idea.

You might get answers from this newsgroup. But if you don't, you may want to
post a similar question to:
news://msnews.microsoft.com/microsoft.public.vb.winapi

(mention that you're running it as VBA from one of the instances of Excel.)
 
Top