Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List of open workbooks
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
List of open workbooks
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 "anamarie30" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List of open workbooks | Excel Programming | |||
List Open Workbooks in a combobox | Excel Programming | |||
Dialog Box List of Current Open Workbooks | Excel Programming | |||
Getting list of open workbooks | Excel Programming | |||
List Open Workbooks in VBA | Excel Programming |