"Tetsuya Oguma" <Tetsuya wrote in message
...
G'day,

Thanks Rob.

XLLs, COM add-ins, and Automation Add-ins are not programmed in VBA, so
they do not appear in the VBE.
Mmmm, if I want to look into the internals i.e., the defined functions in
the XLL file, how can I do that? Is this possible?

Hi Tetsuya,

If the functions in the XLL were designed to be worksheet functions (the
most common use of XLLs these days), you can use the Excel function wizard.
The only problem is that depending on how the author of the XLL decided to
classify the functions it may or may not be obvious which ones they are.

If the author chose to create a new custom category to contain the
functions in the XLL then it will be pretty obvious. When the XLL is open
you will see a category in the function wizard that did not appear when the
XLL was not open. Within this category will be the functions contained in
the XLL. However, the author of the XLL can also choose to add the XLL
functions to Excel's built-in function categories, in which case you have to
look through each of them for functions you don't recognize as built-in
Excel functions.

It's also possible that an XLL isn't designed to add worksheet functions
at all. An experienced C/C++ programmer can use an XLL to do anything a VBA
add-in can do and more. If this is the case you'll have to look for menus or
toolbar buttons the XLL might have added and if you find them, experiment
with them to see what they do. But in the end, it's possible you just won't
be able to find out anything significant about an XLL unless you have some
documentation that goes with it.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *