Excel 2003 - How to build my own XLA?

vba excel excel-2003 xla
Justin picture Justin · Apr 7, 2010 · Viewed 11k times · Source

How can you make the .xla file if you want to create your own xla? I have the code, classes, shapes, etc....what is the process to making an xla file to point to? I know that I have to put it in my program files folder, and then go through the steps to adding an "add-in" in xls...but i mean actually saving an xla file to point to....

can i simply write all this in xls and then save it as file type xla?? because i have tried to do that but I get an error that it is not a valid add in when I am in a spreadsheet trying to point to it?

thanks!

Answer

James Campbell picture James Campbell · Apr 7, 2010

This should help:

Create an .XLA file

http://www.vbaexpress.com/forum/archive/index.php/t-496.html

http://www.xtremevbtalk.com/archive/index.php/t-62362.html

http://www.ehow.com/how_5066365_create-excel-xla-addin.html

Creating An XLA Add-In For Excel

http://www.cpearson.com/excel/CreateAddIn.aspx

Microsoft Excel VBA Macros. How to Create an Excel Add-in For Them

http://www.ozgrid.com/VBA/excel-add-in-create.htm

Excel VBA - install an Excel Add-in (XLA or XLL)

http://vbadud.blogspot.com/2007/06/excel-vba-install-excel-add-in-xla-or.html

If you are still having issues let me know...

Related questions

Loop through each row of a range in Excel

This is one of those things that I'm sure there's a built-in function for (and I may well have been told it in the past), but I'm scratching my head to remember it. How do I loop through each row …

Read More
How to show current user name in a cell?

In most of the online resource I can find usually show me how to retrieve this information in VBA. Is there any direct way to get this information in a cell? For example as simple as =ENVIRON('User') (which did …

Read More
Get User Selected Range

How can I get a range of cells selected via user mouse input for further processing using VBA?

Read More