Workbooks collection

[Dave]

Hi,
XL2003

When I enter: < ?Workbooks.Count > into the immediate window, I only get a
count of workbooks that are open within the active instance of XL. ie, if the
Window menu lists 3 workbooks, then 3 is returned.
However, if there are other instances of XL open on the computer, which do
not appear in the Windows menu, they are ignored.
Is there a way of counting all the open workbooks, regardless of whether or
not they appear in the Windows menu?

 

[Dave]

Hi Leith,
It would be best if I could do it. The operator has to have two workbooks
open - the master, and one other, from which a macro will import data. I am
trying to check if the op has just 2 books open. Since I won't know the name
of the second book, I was hoping to use the Workbooks.count thingy to do
this, then select the workbook that is not the master, etc, etc.
But yes, it is fun. But also necessary.
Regards - Dave