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;189707 Wrote:
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?

Hello Dave,

It can be done using VBA and API calls and possibly some WMI scripts.
The real question in my mind is this for fun or do you really need do
this?


--
Leith Ross

Sincerely,
Leith Ross

'The Code Cage' (http://www.thecodecage.com/)
------------------------------------------------------------------------
Leith Ross's Profile: http://www.thecodecage.com/forumz/member.php?userid=75
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=52258

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

"Leith Ross" wrote:


Dave;189707 Wrote:
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?

Hello Dave,

It can be done using VBA and API calls and possibly some WMI scripts.
The real question in my mind is this for fun or do you really need do
this?


--
Leith Ross

Sincerely,
Leith Ross

'The Code Cage' (http://www.thecodecage.com/)
------------------------------------------------------------------------
Leith Ross's Profile: http://www.thecodecage.com/forumz/member.php?userid=75
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=52258