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