+ Reply to Thread
Results 1 to 4 of 4

Hosting Macros on Network that may be updated freq. that users' local files can run

  1. #1
    Registered User
    Join Date
    06-22-2009
    Location
    OP,KS
    MS-Off Ver
    Excel 2003
    Posts
    17

    Hosting Macros on Network that may be updated freq. that users' local files can run

    I have a set of macros in a template/starter file for users to open and start a project. Within this workbook contains a bunch of macros. Instead of sending everyone a new workbook with updated macros each time, I would like to host these macros or somehow distribute updated macros to everyone efficiently.

    I am unsuccessful in finding a way to have a button call another macro from a workbook on a network drive.

    I am also unsuccessful in using an addin. I have saved the macros as an add-in and added it to my workbook, but am unable to call those functions.

    I could also just export the modules each time one updates but then I have to rely on the user to replace their current one which I don't want to do.

    Essentially, I would like the update to occur without relying on the user to do very much or anything at all.

    Thanks

  2. #2
    Registered User
    Join Date
    06-22-2009
    Location
    OP,KS
    MS-Off Ver
    Excel 2003
    Posts
    17

    Re: Hosting Macros on Network that may be updated freq. that users' local files can r

    Would it be worth/possible to just have the template/starter file that uses those functions to open up the blank excel file from the network (hidden-ly) to call those functions from it?

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Hosting Macros on Network that may be updated freq. that users' local files can r

    I would think the addin is the best solution, but you will probably need a menu to call the code

    AddMenu.zip
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Registered User
    Join Date
    06-22-2009
    Location
    OP,KS
    MS-Off Ver
    Excel 2003
    Posts
    17

    Re: Hosting Macros on Network that may be updated freq. that users' local files can r

    Thanks for the file. Much nicer than adding a toolbar in my opinion. I will test it this week. Want to make sure I don't have any referencing issues with workbooks, etc.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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