List of open workbooks

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
Back
Top