microsoft excel training - .xla files

Resolved · Low Priority · Version Standard

Tue 15 Jan 2008, 15:25 Delegate 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:47 Trainer 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 courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Display Functions on Worksheets

Functions in Excel can be difficult to recall their format/syntax

For example, you want to use the =PMT function.

Enter =PMT, then select keystroke, CTRL+SHIFT+A.

This usful memory jog, will display the arguments of a function on a worksheet, allowing the user to proceed with the generation of the function

View all Excel hints and tips