Open Workbooks Return

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

Guest

How do I programmically return the currently open workbooks so as to load a
ComboBox?
 
Here is how to get the workbooks...

Sub ListBooks()
Dim wbk As Workbook

For Each wbk In Workbooks
MsgBox wbk.Name
Next wbk
End Sub

Load the combo box where the message box currently lives. This will only
look at one instance of Excel. If the user were to open two copies of Excel
you would only get the workbooks from this one instance. Dealing with two
instances of Excel is distinctly difficult.

HTH
 
Jim,
Thanks a bunch! I totally had my thinking cap off. Thanks for rattling the
brain for me.
Trent
 
Don't feel bad. My brain rattles at the best of times... Just ask my wife. :)

Glad to help...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COM addin won't connect when workbook opened via another workbookfrom another instance 3
Excel Protection 2
How to open a specific worksheet via code from workbook_open 1
Adding Items at runtime in the Ribbon ComboBox 3
How to open a specific worksheet via code from workbook_open 5
Inputbox from another OPEN workbook 5
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Excel 2013 menubar incompatibility? 1

Back
Top