Hi everyone,

Is there a way of getting the index of an open workbook (its position in the collection) from its name?

So for instance I can do this (in the immediate window):
?Workbooks(2).Name

and I'll get back the name of the second workbook, "Feb_Sales.xlsx".

But I can't do something like this:

?Workbooks("Feb_Sales.xlsx").index

But, you can use 'index' like this on Worksheets within a Workbook. Is there an equivalent for doing the same thing for Workbooks?

Any pointers, gratefully received as always.