How can I Export and import Excel Macro from an Excel Template in Centralized location? Whenever user opens the Template this code gets imported at runtime.
All macro code in file1 kept in Shared drive.
Whenever any user opens Template it gets all the code for macro from this Shared Drive --> template.
For that I need to have some code within all the templates to get this code from shared drive.
i) Importing macros
ii) have all code in VBS format in the shared drive
But for First solution it not working. I will show you what I have worked on and could you please tell me what is wrong.
Please find the code which i have worked on however has issues with it when import line is execute. It doesn't perform any action though it executes that line.
Bookmarks