Hi,

How can i list in VBA all open workbooks in multiple running
applications ?

I want to list them in a listbox, and activate a workbook by clicking
the name in de listbox.

Thanks,

wbl


---
Message posted from http://www.ExcelForum.com/

I believe you would have difficulty doing it outside the existing instance
of Excel, but your terminology may be imprecise and you are only talking
about the current instance. For a single instance of Excel:

for each bk in Application.workbooks
Userform1.Listbox1.AddItem bk.name
Next

--------------------

workbooks(Userform1.Listbox1.Value).Activate

--------------------

--
Regards,
Tom Ogilvy

"wbl " wrote in message
...
Hi,

How can i list in VBA all open workbooks in multiple running
applications ?

I want to list them in a listbox, and activate a workbook by clicking
the name in de listbox.

Thanks,

wbl


---
Message posted from http://www.ExcelForum.com/

The problem is that I want to do it outside the existing instance !

The problem is to change between running Excel applications.

Regards,
Wbl


---
Message posted from http://www.ExcelForum.com/

To get a listing of workbooks open in additional instances of the Excel
application would require an automation link to the instance I believe. I
haven't seen any code or method to do this. You can enumerate windows and
identify processes, but I haven't seen any code that shows how to convert
this to an automation reference to the excel application in that instance.

--
Regards,
Tom Ogilvy


"wbl " wrote in message
...
The problem is that I want to do it outside the existing instance !

The problem is to change between running Excel applications.

Regards,
Wbl


---
Message posted from http://www.ExcelForum.com/