VBA Workbook number

[jakobt]

I have workbooks open.
Want to write a variable which identifies which number the current activated workbook is?

 

[Logit]

.
See if this helps :

https://stackoverflow.com/questions...unting-and-storing-list-of-all-open-workbooks