Printable View
Hello,
I need help because I want to do something and I don't know if it is possible.
I have a macro that I have to update every 2 months more or less, and when I update it I have to tell my coworkers that they need to update the macro in their personal book of macros.
Is there any way that when I update the macro, these updates affect automatically to my coworkers' macros?
I try to create a macro that once is executed it open the macro of a specific word document but it doesn't work.
Thank you
The short answer is no. Your best bet is to save the macro in a template and distribute that template as an add-in. When it needs changing you can save the updated template in a self extracting zip file and the users can use it to update their copies.
What I am doing now is after updating the macro, send a email with the instructions to update their macro in their computers. They just need to delete a module and copy the new one.Quote:
Originally Posted by gmayor
with the comand "application.run ()..." I have tried but it doesnt work.
Is it imposible to launch a macro from one file in an other file?
Another approach would be to maintain the macro in a template stored in a folder your co-workers can access. Any documents based on or attached to that template will automatically have access to the template's code.
And, yes, Application.Run does run macros stored in other Word documents. See the Word VBA help file for further details.
For what it's worth, after all of the above:
I have a macro-enabled template containing over 100 procedures, which I'm constantly adding too or correcting. My colleagues are using all of these macros, accessed from a custom ribbon tab in Word; so how do I roll out updates?
1. Everyone has their own version of the macro-enabled template in their Word startup folder.
2. I have put a copy of this template in a network location available to everybody.
3. I run an update macro when I'm happy with my corrections/additions which overwrites the network version.
4. I tell my colleagues I've made some change by email.
5. They have a similar update macro in their Normal.dotm which is accessible via a custom button on the Word ribbon.
6. This macro copies the network version and overwrites their own version.
So it's all done with clicking buttons on the ribbon. The basic code structure I found here: https://wellsr.com/vba/2018/excel/vb...-fso-copyfile/