+ Reply to Thread
Results 1 to 3 of 3

How to store VBA code modules centrally

  1. #1
    Forum Contributor
    Join Date
    03-01-2019
    Location
    New York, New York
    MS-Off Ver
    Office 2016 for Mac
    Posts
    125

    How to store VBA code modules centrally

    At the moment, all of the VBA code we use is stored locally on my computer in my Personal Workbook file. However, I am interested in migrating 3-4 modules of code so other users can use these macros. As the code needs to be updated on a regular basis and used on more than one file/project, it is not efficient to store the macros in each file rather than the Personal Workbook. Any suggestions on how the macros can be stored centrally on the server and accessed by any user who has access to that server rather than copying to each user's computer every time an update occurs?

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: How to store VBA code modules centrally

    Have a read up on addins, sounds like exactly what you’re after

  3. #3
    Forum Contributor
    Join Date
    03-01-2019
    Location
    New York, New York
    MS-Off Ver
    Office 2016 for Mac
    Posts
    125

    Re: How to store VBA code modules centrally

    Thanks for the reply. I may have found a related/unrelated fix. Not familiar with addins. I have moved the Personal Workbook file to the server/changed the file path of what Excel should open at startup and the macros are running fine. The question is whether updates to the code will save properly across users accessing the server.

+ 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. macro 4 sheet Mysterious appearing Worksheets & Modules. Codes transferred to New Modules
    By Doc.AElstein in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-24-2016, 07:07 AM
  2. [SOLVED] Symbols in cells - how to centrally re-align?
    By zari in forum Excel General
    Replies: 2
    Last Post: 12-03-2015, 07:05 PM
  3. When to code in the different modules
    By Excel_vba in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-23-2013, 03:22 AM
  4. Centrally aligned bar graph
    By anantha610 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-23-2012, 05:14 AM
  5. Centrally controlled Excel Macros
    By gyro11 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-06-2009, 01:58 PM
  6. Centrally align 2D stacked bar chart
    By MrDean in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 08-22-2008, 09:32 AM
  7. [SOLVED] Modules and code
    By Metrazal in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-24-2006, 09:28 AM

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