Hi,

If it helps, the indices will be in the order in which the workbooks are
opened.

regards,
Don

"Dale" wrote in message
...
Hi
I have 7 workbooks open at the same time. I use the master workbook to
copy one of each of the master worksheets into each of the other open
workbooks. How do I retrieve the index and not the name of each workbook?
i.e.
workbook(2) and not workbook("test.xls").


Thanks for your help.