Hi,
I'm wondering if there is possible to automatically install an addin when opening a Workbook?
Can the add in be saved "inside" of the workbook, or will it have to be a separate .xla/.xlam (don't really know the difference) file?
The workbook will be saved on a network disc so that several people can find it.

I'm also curious about a function to update the addin if new functionality is required etc. I've made a button which checks the current version(just a text caption on a userform) vs the newest version (last part of the name of the workbook saved to the network disc) e.g. myAddIn1.0.xlsm. This might not be the best way to do it, as I am depending on that no one changes the name / moves or deletes the file.


All functionality is coded inside an userform, except the Userform1.show which is located in module1.

Hopefully I have provided sufficient info here so that someone can help me

BR.
Joachim