Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. -- raypayette ------------------------------------------------------------------------ raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569 View this thread: http://www.excelforum.com/showthread...hreadid=565959 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a chart with wide range of numbers | Charts and Charting in Excel | |||
Excel 2007 Function Library | Excel Discussion (Misc queries) | |||
How can i create new function library ??? | Excel Worksheet Functions | |||
How to create module wide 'constant'? | Excel Programming | |||
gcTCPObjLib.dll use as Excel function library | Excel Worksheet Functions |