excel: thisWorkBook not working.
I am finding that thisWorkBook returns the ActiveWorkBook.
I can solve the problem by making sure that this is the only workbook open, but then the VBA is not very stable to distribute.
I can also search the workbooks for the name of my workbook, but then I have to be sure that the name doesn't change.
is this defect in excel or am I doing something wrong ?