Workbook Index numbering

[julhs]

Want to understand the order of WorkBook Index numbering.
Suppose:
In my Excel StartUp folder I have, “PERSONAL.XLSB” and “xl2bb.xlam”
On opening Workbook “Me” it opens a second Workbook (“Me Plus One”)

So query is; what is the index number of each Workbook opened?
My, quite probably slued logic is:
Excel StartUp folder = Index 1
Workbook “Me” = Index 2
Workbook “Me plus One” = Index 3

Other possibility is (and most likely) I completely misunderstand the whole Index numbering thing.!!

 

[julhs]

Taken me a while to get back to resolving this query, been a bit side tracked.
Came up with the below that returns the answer to my query.

Option Explicit
   Sub WorkbookIndexNameLoop()
   Dim wb_Count As Integer
   Dim I As Integer

       ' Sets wb_Count equal to the number of Open Workbooks
   wb_Count = Workbooks.Count

       ' Begin the loop.
   For I = 1 To wb_Count

      ' The following line shows the reference to ALL Open Workbooks (one by one) within
      ' the loop and increments (accordingly) the Workbook Index# and shows its WorkbookName in a dialog box.
      ' Workbooks (" & I & "), is the part that does the incrementing

    MsgBox "Workbooks (" & I & ")  is" & vbCrLf & vbCrLf & Workbooks(I).Name
 
   Next I
 End Sub