You can always reach the correct folder if you user %USERPROFILE%\DIR.

If you want to install there, it's a good idea create a INSTALL.BAT file. You
will want to put it into a ZIP file. Is also a good idea create a
_UNPACK_ME!!!.TXT file  and a README.TXT file both with instructions.

About the filename changing by the user, you can avoid this if you follow the
ZIP Pack with method. Since the INSTALL.BAT will do all the service and put the
XLA into a unused folder by the user (not frequently like My DOCUMENTS), the XLA
file will be very far from the "dangerous" user. Other good reason to distribute
via Zip Pack is that if you put the XLA into a website or a intranet site, you
will probably have a lot of problems with filename.

So, Zip is a solution that I have been using and with very good results. See
that with ZIP file I can do this:

LOS_Tools_v1.0.zip
LOS_Tools_v1.1.zip
LOS_Tools_v1.2.zip
LOS_Tools_v1.5.zip
LOS_Tools_v2.0.zip

...but inside of them all, the XLA is always THE SAME, because I want to
overwrite by the old. After the install/update process, the Users' Excel will
not scream "Hey man, where is my XLA?!!!". And, finally, another great reason to
pack into a ZIP file is that I can even put a PDF file with small printscreens
if a User Guide is needed. But on my daily work, I put the User Manual on a
separated PDF file because I have minor changes between the versions and I use
to announce the "New features" by e-mail.

Well, I hope it can help you on your daily tasks... Please don't hesitate to
give a feedback.