Samantha has attended:
Excel VBA Intro Intermediate course
.xla files
i am very confused with .xla files.
i have two directories - each one has a "talisman.xla" file which contains subroutines for execution of various programs. but each one is different.
i presumed that when i open up a spreadsheet in directory 1, it will use the .xla file in directory 1.
and then wehn i open up a spreadsheet in directory 2, it will use the .xla file in directory 2.
but this doesnt seem to be the case.
how do .xla files work and why is my directory 1 spreadsheet using the .xla file in directory 2?
please can anyone help?
RE: .xla files
Hi Samantha
A .xla file is an Add-In file, Which allows the code to be run on whichever computer its loaded on.
1. To install an Add-In in Excel :
2. Select Tools from the menu and Click Add-Ins
3. Add the relevant Add-In
After doing the above the Add-In is always installed and available.
It sounds like in your case only the Directory 2 .xla file has been loaded.
You should also load the one from Directory 1 since according to you it has different subroutines.
NB You need to be careful with the .xla files and subroutine names.
If both xla files and subroutine names are dupplicated you may cause errors to occur as the computer won't know which one to run.
Hope this has helped
Carlos
