.xla (Excel:Add in)

Posted: January 23, 2009 in Computer, ms-excel, Under the hood
Tags: , , , , ,

Macros are very powerful tool in Excel. One can create all logic and funda in them and use them repeatedly. But when it comes to distributing a macro, its a real pain. Recently I came across that same problem when one of my colleague asked me to create a function to spell the amount in words, also he wanted the this funtion could be distributed easily to other clients also. Working on the problem I came across Excel Add in.

An Excel Add-In is a file (usually with an .xla or .xll extension) that Excel can load when it starts up. This is a very convieneint and Infact meant for the purpose of distribution.

How to create: Open an Excel file, Press ALT + 11, this will open a VBA window as shown here

Excel Add In (.xla file)

Excel Add In (.xla file)

Put your code in the function and save it.  File>Save as \ Microsoft Excel Add-in (*.xla). Once saved and re-opened the Workbook will be hidden and can only be seen in the “Project Explorer” via the Visual Basic Editor. It is NOT hidden in the same way as the Personal.xls as this can be seen (and made visible) via Windows>Unhide.

Once completed users can easily install your Add-in like below

  • Save a copy to C:\WINDOWS\Application Data\Microsoft\AddIns\ . If not any location, just take note of it for step 4.
  • Open any Workbook.
  • On the Tools menu, point to Add-Ins and click Browse. Locate your add-in from where you saved it, select it and then click OK.
  • Ensure your add-in is in the Add-ins available: box and it is checked.
    Now click OK and the add-in is installed.

Yes You have done it. Voilla, Add In is installed and will be available to any excel you open now. You can use the function written in xla files (shown as above) like any other microsoft build in function.

Enjoy the Excel Power!!!! Please do write in case any addtions, suggestions and comments, these matters a lot to me 🙂

Advertisements
Comments
  1. JP says:

    You’ll want to do a few other things as well:

    Go to File > Properties and fill out the Comments section with a description for your add-in. The description you type will appear in the Tools > Add-Ins box when someone installs the add-in.

    Also, if you change the name of the project from the default “VBAProject” it’ll be easier to reference from other projects, for example if you want to use a function from an add-in in another project.

    • vijvipin says:

      Hi, thanks for this useful update, this surely helps when adding the Add-Ins, giving a small description to the user as with the existing Add-Ins. Please keep sharing knowledge with others.

      Thanks and Regards

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s