+ Reply to Thread
Results 1 to 4 of 4

Distribute macros among other computers

  1. #1
    Registered User
    Join Date
    12-09-2017
    Location
    Israel
    MS-Off Ver
    Office Excel 2007
    Posts
    42

    Distribute macros among other computers

    Hi, I have on my copy of Word a number of vb components (modules and forms). And now I'd like to distribute my macros to others. I don't want to have each person (or me) manually importing the associated vb components but rather coping them in a way that doesn't involve opening the VBE. I could copy my entire Normal file with all the macros in it already, and simply replacing it with the old one on the other computers. Is this the only way to do that (sercumvanting the VBE interface)? One disadvantage doing it this way is that it would overwrite any existing macros other computers might have in their Normal file. In that case, in order to keep them as well, they will have to be imported via the VBE, right?

    Is the a way to maybe make an exe that does it - replacing the Normal file with another, that also warns about overwriting? Is it relatively easy to accomplish using a designated exe-generated program for dummies? (I'm not at all experienced in making exe files).


    Thanks!

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,696

    Re: Distribute macros among other computers

    It sounds like you are talking about Word, not Excel.

    I have the default Normal file and I also have a JeffMacros.dotm file that I put in the Word startup folder. It automatically opens the macros when Word starts, but does not open the file in the Word interface.

    This is much better than trying to merge macros into or replace Normal or creating an exe to do any of this. You can also have two macros with the same name in the two files.

    The file can be saved in the right place with a macro. I have attached a sample macro file. When the user clicks the button, it saves itself to the Startup folder then closes. You just need to load your macros into this file for distribution, or copy this code to your other file and distribute that. Make sure you make it a .dotm file.
    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,696

    Re: Distribute macros among other computers

    Moved from Excel Programming / VBA / Macros

  4. #4
    Registered User
    Join Date
    12-09-2017
    Location
    Israel
    MS-Off Ver
    Office Excel 2007
    Posts
    42

    Re: Distribute macros among other computers

    hi 6StringJazzer,
    thanks for the very helpful input! plus for moving the thread to the right place!
    Last edited by guyglk; 07-06-2021 at 01:26 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macros Excel File does not Work on All Computers
    By Peaceofcake in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-30-2017, 12:37 PM
  2. Macros are working on some computers on network but on others they are not
    By sdecker143 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-31-2016, 12:02 PM
  3. Getting sheets with macros to work on other computers.
    By The Toke Master in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-13-2016, 09:49 PM
  4. Making macros available on multiple user's computers as an add-in
    By Ruandi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2013, 03:45 AM
  5. run macros on entire network of computers once clicked
    By myjebay1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-19-2012, 05:55 PM
  6. Macros on other computers....
    By Sparkybear in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-24-2008, 09:47 AM
  7. How do I transfer macros in excel between two computers?
    By diningdesk in forum Excel General
    Replies: 1
    Last Post: 06-28-2005, 12:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1