98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » microsoft excel training - .xla files
microsoft excel training - .xla files
Resolved · Low Priority · Version Standard
Tue 15 Jan 2008, 15:25Delegate Samantha said...
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?
Fri 29 Feb 2008, 11:47Trainer Carlos said...
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
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Display Functions on WorksheetsFunctions in Excel can be difficult to recall their format/syntax |
