If you need the same macro in different workbooks you currently have only 2 options:
- copy & paste the macro into all relevant workbooks
- use external PHP files.
But external PHP files are not really handy when you want to provide deployment packages of your reports. Furthermore it makes maintenance more clumsy if you have your codes in 2 different places.
It would be great if you could create central/global macro modules directly in the file manager. Those then could be referenced and used in different workbooks:
require module ("MyGlobalModule2");
Another alternative for better reusability could be to access macro modules from other workbooks which are assigned as resource:
require module ("MyGlobalWorkbook->Module2");
This would also fix the lacking functionality of global .php macro files on the cloud jedox, where we are current restrained to sending the files to jedox cloud who will then upload them ad-hoc....