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.