AddIn.Path property

[goranimo]

Hi,

I have an Macro Addin that is shared with my coworkers.

The Addin is located in a shared folder, in that way I can edit the Macro without anybody have to reinstall macro. Even though I tell them to not save the Addin locally during installation, some of them do it anyway, and will then miss the updates.

I was thinking that I could add to the Macro that it would check the Addin location before running any codes. If Addin is loaded from shared folder, then run the code as usual. If it is loaded from local folder, then message box "Please reinstall Macro to Shared Folder"

I tried using AddIn.Path with no luck.


Any ideas?

[romperstomper]

Assuming it's an xlam add-in, you should use ThisWorkbook.Path

[goranimo]

Thank you!