Consulting

Results 1 to 4 of 4

Thread: Shared macro with my coworkers

  1. #1
    VBAX Regular
    Joined
    Feb 2019
    Posts
    16
    Location

    Shared macro with my coworkers

    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

  2. #2
    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.
    Graham Mayor - MS MVP (Word) 2002-2019
    Visit my web site for more programming tips and ready made processes
    http://www.gmayor.com

  3. #3
    VBAX Regular
    Joined
    Feb 2019
    Posts
    16
    Location
    Quote Originally Posted by gmayor View Post
    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.

    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?

  4. #4
    Knowledge Base Approver VBAX Guru macropod's Avatar
    Joined
    Jul 2008
    Posts
    4,093
    Location
    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.
    Cheers
    Paul Edstein
    [Fmr MS MVP - Word]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •