Seems silly, but I can't find a way to get the index number of the active workbook. I have a file which will be renamed every day, so I can't use the filename as a method of referring to it (I need to switch back and forth between two files, so I need a way to refer to both; the other one has a constant name, so that's not a problem).
I thought something like:
intShtNum = ThisWorkbook.Index would work, but it doesn't.
Any thoughts?
I thought something like:
intShtNum = ThisWorkbook.Index would work, but it doesn't.
Any thoughts?