MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Creating XLA, pieces of puzzle missing, or is it just my mind that's scrambled?

Posted by Kevin James on April 25, 2001 10:18 PM

I'd like to hear Dave Hawley's input on this, but all are welcome to reply.

I read article:

which covered creating an XLA (add-in).

My question. I have a Highlighter (greenbar) macro/adultrated VBA I wrote. (Budding pgmrs make sure dangerous creatures.) If I follow the instructions to create the VBA, how do I deploy and instruct others how to install it?

Highlighter file at: (broken link)

Posted by Dave Hawley on April 25, 2001 10:27 PM

Kevin, I'm about to read the article now. Are you asking how to install a new Add-in ?


OzGrid Business Applications

Posted by Kevin James on April 26, 2001 6:35 AM

yes, kinda

Hi Dave,

You know, sometimes not even I know what I want.

My question comes down to: After I've created the XLA file, does it add-in the same as add-in products?

Posted by Dax on April 26, 2001 2:16 PM

Re: yes, kinda

The answer is yes. Add-in products are the same as a file you save as *.xla

Once you've created the file you'll be able to add it in by selecting Tools, Add-ins, Browse and find your add-in. Once there the add-in will be available in your list until you delete the add-in.

Posted by Kevin James on April 26, 2001 2:40 PM

thanks see body of msg.


I very much appreciate you reply. I needed that warm fuzzy assurance before doing it and then finding I did some irreversible damage.