Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Someone has put lots of Macros in blank XLS documents, and now someone has aked me to put them into an XLA document. Why and for what purpose?

The Macro's loop through opening workbooks and copy/pasting their data into the active workbook; and then saving as.

What's the benefits of an XLA?



share|improve this question
up vote 0 down vote accepted

XLA can be defined as MS Excel Add-in file format. Add-ins provide an excellent way of increasing the power of Excel and they are the ideal vehicle for distributing your custom functions. XLA format is meant for saving functions that can be shared by many other workbooks, it's not meant for saving workbooks.

share|improve this answer
So you would have your macros (code) in separate XLA's and then have a separate workbook call those XLA's when required. That way it's easier to manage upates and 'DRY' principles. So all my colleague needed to do was save as XLA rather than XLS? – RocketGoal Jul 15 '10 at 11:20
Apparently yes. – Mehper C. Palavuzlar Jul 15 '10 at 11:39

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .