Printable View
I am using an XLAM file - will ThisWorkbook.Path always return the path of the XLAM file - even if I read in data from other macro embedded files? - I need to read the path of the XLAM file as I have support file in a subfolder below where the XLAM reside.
Hi,
from excel help file...
Quote:
Use this(ThisWorkbook) property to refer to the workbook that contains your macro code. ThisWorkbook is the only way to refer to an add-in workbook from inside the add-in itself. The ActiveWorkbook property doesn't return the add-in workbook; it returns the workbook that's calling the add-in.
What I was hoping = Guess I should use help more often - thanks