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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COM addin won't connect when workbook opened via another workbookfrom another instance 3
Pulling data from one workbook to another one using VBA 0
Reference named range in closed workbook 23
Scattered array cells copy to scattered array cells another workbook 14
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
How to reference a cell from anther workbook without opening it 0
Save As and new workbook new name used in existing code 8
finding the index # of a workbooks 2

Back
Top