Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

xla format

ResolvedVersion 2003

Selva has attended:
Excel VBA Intro Intermediate course
Excel Advanced course
Excel Pivot Tables course
Excel PowerPivot course

.xla Format

Hi Anthony,

I saved an .xls file with macros as .xla and when I opened the file there were no deatils. How do I link the add ins?

Thanks

Selva

RE: .xla Format

Hi Selva, thanks for your query. Go to Tools > Add-Ins to open the Add-Ins dialog and use the [Browse] button to find it. Place a tick in the check-box next to your Add-In's name and click [OK]. Your macros should now be accessible but check the macro security settings on your machine (possibly also with IT if you can't see the macros).

Hope this helps,

Anthony

RE: .xla Format

Thanks Anthony

Selva

Thu 4 Feb 2010: Automatically marked as resolved.

 

Training courses

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Saving your Excel Spreadsheet as a CSV File

In situations where you need to save your Excel spreadsheet as a CSV file, follow these simple steps.

Click the File tab and click Save As.
Enter a name in the File name field.
Click the drop-down arrow next to the Save as type field to select the file type. Scroll down the list and select CSV (comma delimited) (*.CSV)
Click Save

The data will now be saved to a separate CSV file which can be used in different applications.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.