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/