Found a way to do it. Here is a summary:

Excel 2007 under Vista seems to save XLA files in
C:\Users\Ed\AppData\Roaming\Microsoft\AddIns which is a hidded directory. To
send it to another computer
I have to first get at it. Only way I've found is to do a Search for
JOCCheck.xla on C:. This will bring up a SHORTCUT to it in Recent items
folder.
Clicking on Properties will reveal that the Target of the shortcut is
C:\Users\Ed\AppData\Roaming\Microsoft\AddIns\JOCCh eck.xla, which is the
actual file.
Click on Open file location, then select the file and do a CTRL-C to copy,
then paste to the wanted location, e.g., C:\JOC\Membership. It can then be
moved to the other machine and into the desiered directory. . On that
machine, go to the AddIns dialog, browse to the same directory and select
the addIn.xla.

Ed



"Chip Pearson" wrote in message
...
How are you distributing and installing the xla on the users'
machines? You can tell the user to save the file you distribute to a
specific directory, or you can create a VBS install script (or even a
SetUp.exe install program) to move your add-in to the appropriate
location.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Wed, 14 Jan 2009 12:24:37 -0800, "Ed Sowell"
wrote:

I have written VBA functions nad menus that operate on a Workbook to be
used
by another person. I packaged the VBA stuff as an AddIn so when I update
it
I can just send him a new Addin .xla file without having to synchronize my
working .xls file with his .xls file that hass all the most current data.
This has been in place for some time now and it has all worked fine. I
just
send him a new .xla file and tell him to put in the same directory where
his
.xls file is. All of this was developed under XP Pro and using Office
2003.

More resently, I changed my development platform to Vista and Office 2007.
I
have also written a second AddIn that has some optional features I don't
want integrated with the original AddIn.

Now, to the problem. Vista/Office 2007 insists on saving the new aAddIn
.xla
file in my Users.Ed/AppData/Mictosoft directory, which is hidden so I
cna't
even find it in Windows Explores. I did find that I could get to it but
when
I try to copy it some place else so I can send it to my user I discover
thhat all I can create elsewhere is a shortcut, which I can hardly port to
another machine. Any changes I make to the new addin are made to the copy
it
keeps in the hidden directory.

How can I force Excel/VBA to save the new addin in a place where I can get
my hands on it?

TIA

Ed