microsoft excel training - .xla files

The UK's most regular instructor-led training courses.
Training information: microsoft excel training · Excel courses london · VBA training in London

Resolved · Low Priority · Version Standard

.xla files

Samantha has attended:
Excel VBA course

by - delegate Samantha [21 posts] (2008 Jan 15 Tue, 15:25) Reply

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?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Oct 14 Tue	Bloomsbury	0	FULL
2002/XP	2008 Oct 14 Tue	Tooting	0	FULL
2003	2008 Oct 16 Thu	Southwark	5	book now	£198	£215
2002/XP	2008 Oct 21 Tue	Tooting	0	FULL
2003	2008 Oct 21 Tue	Bayswater	4	book now	£195	£205
2003	2008 Oct 23 Thu	Bloomsbury	1	book now	£215	£215
Full Schedule: See all 125 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: .xla files

by - trainer Carlos gold contributer [439 posts] (2008 Feb 29 Fri, 11:47) Reply

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

· Fun Things I've Done With Excel
· Microsoft Excel Training: Not Just for Newbies Anymore
· Advanced Excel Training - takes you to the next level
· Microsoft Excel Training - Numerical excellence for all
· Excel Macros for the Non-Programmer

Excel tip:

Change the Value of a Constant

When using a named constant in a worksheet, you may wish to change the value of that constant.

From the 'Insert' menu, select 'Name', then select 'Define'.

In the 'Define Name' dialog box, select the constant that you want to change.
Change the value in the 'Refers To' box.
Click OK.

Wherever that named constant has been used it will now use its new value.

View all Excel hints and tips