How to retrieve index of workbooks

  • Thread starter Thread starter Dale
  • Start date Start date
D

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.
 
Hi,

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

regards,
Don
 
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.
 
Back
Top