Referencing a Workbook by Index

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.

Hi Jamsta1972,

A quick look in the object browser shows that there doesn't seem to be an equivalent property for the workbook class, but there's nothing to stop you creating your own array of workbooks.

Cheers,
Dom

OK, thanks guys. A loop it shall be!