Do you have any hidden workbooks open (eg. personal.xls) ?

Tim

--
Tim Williams
Palo Alto, CA


"EAB1977" wrote in message
ups.com...
Hello ladies and gentleman,

I am stuck with a problem and wondering if someome could help me to
figure it out.

What I want to do is to be able to grab the workbook number from a user
that may have multiple workbooks open at one time.

For example, lets say that a user has workbook1, workbook2 workbook3,
workbook4, and workbook5 open. If you go to the Window Menu, you will
see that it looks like:

1 - workbook1
2 - workbook2
etc...

What I need to grab is the workbook number and place it in my code so I
can call it:

strWorkbookName = Workbooks(Workbooks.Count).Name

I thought that this would bring up the latest workbook that was opened,
but this doesn't seem to be the case.

Any ideas?