You can create an XLA file simply by changing the Save As Type to
"Microsoft Office Excel Add-In", at the very end of the Save As
Type list.

Also, I'm assuming that you must compile an XLA

This is incorrect. You don't have to compile XLAs. An XLA is
simply a workbook with an extension of XLA rather than XLS and
the IsAddIn property set to True.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Mike" wrote in message
...
Hello,

I've been working away creating functions in my personal.xls
file, but I'd
like to share these functions with my team members. Would it be
best to just
send my personal.xls around and have them put it into their
XLSTART folder,
or should I create an XLA.

Also, I'm assuming that you must compile an XLA, can you do
this with what
comes with Office 2003 or do I need to install VisualStudio? If
that's the
case, would someone please point me to the documentation? I
have been looking
on MSDN, but its hard when I'm not sure what I'm looking for.

Cheers,