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