Excel add-ins - "xla could not be found" - stop message

H

Harry Flashman

Recently I started using Excel add-ins (xla files) -- which I have
found very handy. For example, I have an add-in that can add a
contents page to my workbook, or the list the file contents of a
folder, etc. The trouble is, if someone, who doesn't have same xla
files on their computer opens my spreadsheet they get a message:
"...xla could not be found. Check the spelling of the file name" etc.
After that they can open file fine. And apart from the messages, there
seems to be no other problem; but I don't see why it is necessary for
this message to occur. The add-ins helped me create the file, but they
do not seem to be necessary to view or use the file.
For example, the Table of Contents sheet, created using an add-in
works fine regardless of whether or not the person using the file has
the add-in. Is there some way that I can stop these messages occuring?
I often send spreadsheets to clients and I don't want them receiving
these error messages.

Harry
 
B

Bob Phillips

There is probably a macro referring back to the xla.

How are the macros in your xla invoked, from a menu?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
H

Harry Flashman

There is probably a macro referring back to the xla.

How are the macros in your xla invoked, from a menu?

I use a few xla files. One them, which consists of a range of
utilities has its own menu/toolbar. The the others have planted
themselves my menus. For exmaple "Table of Contents" is on my Insert
menu, while "List files" is on my Tools menu. One of them "EasyFilter"
I access using right-click.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top