Open Workbooks Return
Jim,
Thanks a bunch! I totally had my thinking cap off. Thanks for rattling the
brain for me.
Trent
"Jim Thomlinson" wrote:
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
"Trent Argante" wrote:
How do I programmically return the currently open workbooks so as to load a
ComboBox?
--
Trent Argante
[DC.J(192)]
|