+ Reply to Thread
Results 1 to 2 of 2

How do I create a company wide Excel function library?

  1. #1
    DoctorG
    Guest

    How do I create a company wide Excel function library?

    I am used to creating generic functions and during these last few days I have
    done so a lot, with help from you all.

    I am wondering what is the appropriate way to store these functions and what
    is neccesary to do or which parameter to set in the client PCs so that these
    functions are available to everyone upon starting Excel. Bear in mind that I
    have already a publicly accessible Templates folder where I store all company
    templates.

    What should be done when we change Office versions?

    Thanks in advance

  2. #2
    Forum Contributor
    Join Date
    12-12-2005
    Posts
    667

    How do I create a company wide Excel function library?

    I would make an add-in of the worksheet containing all my "Public" functions ans Subs simply by saving the file with the *.xla extension and I would place it on a server common to all users. They could simply simply click Tools, Add-in and browse for the add-in in the common directory.
    Best regards,

    Ray

+ 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