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?