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.!!
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.!!