Common Functions and Subs

R

rbnorth

I have a set of common VBA Functions and Subs that are used in several (six)
Excel files. If I change / tweak a procedure in one file I have to change it
in all the other files. Is there a way to set up common modules that are
referenced by all the files? Then I only have to work with one set of
procedures
 
R

rbnorth

Thanks that works well. I didnt know about using the XLSTART directory. Also,
I found that if I save it as a *.XLA, I dont have to reference the
personal.xls file to use it.
Thanks again
 
D

DMB

Hello, I wanted to ask more about the same question so I am tagging along on
our question.

1. what is the .xla you are talking about? Personal.xla?
2. I have 2 modules in my personal.xls w/ functions in them but they I dont
seem to have acess to them from anouther worksheet.

I wrote a function in WS1.xls

Function CopyFormula(sSumRng As Range) As String
Application.Volatile True
CopyFormula = sSumRng.Formula
End Function

so that when I enter this into a cell on a worksheet
=copyformula("A1")

I get the actual formula and not the result. The only way I can get this to
work is by placing this into a module within the current excel workbook that
I am working in. I too want to put all of my functions in a single file,
personal.xls/xla, so that they are available to any workbook. It sounds like
I need to reference the personal workbook and or the function module to make
this work. How do I do that? Or How do I use the xla extension to shortcut
the solution?

Thanks for the help.
 
Top