Add in import for Excel x.

K

Khalid

Hi, I need to import an add in of .xll format to my excel x. The add in tool
does not recognise the format. Any help is greatly appreciated.
 
J

Jim Gordon MVP

Hi,

An Excel XLL file means it is an "Excel Linked Library." It is a part of
the Add-Ins object collection, but does not get used the same way a
regular Excel Add-in does. Most people are familiar with Excel Add-ins
that have an XLA file extension (for Excel Add-in) instead of an XLL.

I say that for clarification so that we get the terminology correct.
That being said, I don't have any XLL files to tinker with, so all I can
do is offer the suggestion that you follow the instructions in Excel's
help file.

To get to those instructions from Excel's menu choose Tools>Macro>Visual
Basic Editor. Once in the editor use Help and search on xll.

There is an example there in the topic "Add-ins Collection Object."
Before you can use an XLL you first have to add it to the list of
available add-ins (there's a code example in the help topic) and then
you have to install it (there's another code example).

There are other examples there on how to run the XLL once it is installed.

-Jim
 

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

Top