xla management

[mikeallen77]

I have written code and saved in .xla format. I want to store this .xla in a
new folder I can easily access via windows explorer and not in excel's
default folder. While I can see this default folder in tools-->add-ins-->
browse, the folder is impossible to find in windows explorer (very odd to
me). I somehow managed to move the .xla to my desired folder and went to
tools-->add-ins--browse, found it, and enabled it. It works fine until I
close and reopen excel. Upon reopening excel and the file using the .xla, I
am alerted of a run-time error saying the .xla cannot be found as it is still
looking in the original, seemingly impossible to find, folder.

The really odd thing is I store plenty of .xla's in my new folder and they
all work fine. I just cannot remember what I did before to have excel look
where I want it to look. Thanks, Mike Allen

 

[Patrick Molloy]

look in Tools/Options and the General tab

 

[Peter T]

I can only assume the reason the addin appeared installed but after closing
& restarting Excel wasn't found is because you had two instance of Excel
running. Any changes will be saved according to the last instance closed.
Best start again.

When you say you are alerted of a run time error I assume you mean the
message that tells you it can't find the installed addin. If you
subsequently get a message asking if you want to remove it click yes.
Otherwise uncheck the addin, close the dialog, re-tick it install and you
should get a message asking if you want to delete the addin. Relocate the
addin and start again.

You can put an addin in any folder you wish (subject permissions). There's a
slight advantage to putting in the default addins folder as it will always
appear in the addins list, even if not installed. Elsewhere it will only
show in the list if ticked and installed, although once installed into the
addins collection it will remain in it indefinitely, even if later unticked,
until you accept the prompt to remove it when not found or edit the
registry.

To get the non-intuitive default addins folder
msgbox Application.UserLibraryPath

Regards,
Peter T