Dynamically Use External Modules

Any ideas?

Well you could transfer the existing procedures to new Add-Ins using Export/Import. Then in your Master Add-In you could write code to open the required Add-In, run the procedure in it and close it again.

Yes...that is exactly what I want to do. How do I do that?

Well, which bit are you stuck on?

1. To open an Add-In

Workbooks.Open Filename:="YourPathYourAddIn.xla"

2. To run a procedure in another workbook:

Run "YourAddin.xla!YourMacro"

3. To close an Add-In

Workbooks("YourAddIn.xla").Close

I find it pretty interesting that we can call external modules on the fly.
And I am planning on using it.

...But...

I am thinking of this moment that will comme eventually where you need to update a certain module that is referenced in many other files and you don't know which ones?
Personnally this is the first road block I see in using this method.

Anybody thought of a way to scan files and look for a reference to this module you are trying to update and avoid user complaints that their excel file is no longer working?