List of open workbooks

[Guest]

I need to add to my main workbook a listbox that show or contain the names of
workbooks that user had open in the computer. The purpose of this is allow
the user to select one workbook instead of write the name of it for doing a
performance analysis. How can I do that?

 

[Chip Pearson]

Try something along the lines of

Dim WB As Workbook
For Each WB In Application.Workbooks
Me.ListBox1.AddItem WB.Name ' or WB.FullName
Next WB