How to retrieve index of workbooks

[Dale]

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.

 

[Don Lloyd]

Hi,

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

regards,
Don

 

[Norman Jones]

Hi Dale

If you open the workbooks in code you could st an identifying object
variable for each, e.g.:

Set wb1 = Workbooks.Open("Book1")
Set wb2 = Workbooks.Open("Book2")

etc.