Do you have a tool available that would enable the automatic update of a selected module across a range of selected workbooks in a folder?
For example, modules are almost always added to / improved with each new client project, but to manually export the newest module then open and replace that module in all other client models would take a lot of time. Anything to automate that process would be helpful.
Thanks!
Hi James - we have developed an API which will enable you to use VBA to do things like this across multiple modular workbooks and projects.
We've been testing the API with some existing users for the past 6 months and they love it, so we'll be releasing it before the end of June 2017.
We'll keep you posted via the Modano newsletter!