I have a problem with determining the path of my xla.
Lets assume I have an xla-addin called MYADDIN.xla
In this MYADDIN.xla i have to determine where the MYADDIN.xla is lacated on my harddrive. On easy way to do this is by using Workbooks("MYADDIN.xla").path
But this requires me to type the name "MYADDIN.xla" in the code. And I'm seeking to avoide this.
So I'm seeking a procedure that can determine the path of MYADDIN.xla within MYADDIN.xla itself. And that is without actually writing the name "MYADDIN.xla".
Can anyone help me?