To call functions in the ATP, once you have set a reference to
the Add-In, simply call them by name, without any prefixing.

rngXIrr = XIrr(...)

If there is a possibility of name collision (e.g., you have a
function with the same name as an ATP function), you can prefix
the function with the library name:

rngXIrr = [atpvbaen.xls].XIrr(...)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"CyberBuzzard" wrote in message
...
I have setup the reference to ATPVBAEN.XLS, and I have also
found the XIrr
function according to what Noman.

The problem I have is that I keep getting the "Object doesn't
support this
property or method" prompt when running code with that function
included like
this:

rngXIrr = Application.WorksheetFunction.XIrr(rng1,
rng2)

The ATPVBAEN.XLS Add-In is installed in Excel.

How do I actually write the code to utilize this function?


--
Any help will be appreciated.

Regards,

CyberBuzzard


"Norman Jones" wrote:

Hi Bruno,

How can I get the list of functions added by ATPVBAEN.XLA?

If you have set a reference to Atpvbaen.xls in the VBE, hit F2
to open the
object browser, in the first dropdown box select
Atpvbaen.xls, in the
Classes pane select VBA Functions. The functions will then be
displayed in
the next pane.


---
Regards,
Norman



"Bruno Campanini" wrote in message
...
"Ron Rosenfeld" wrote in message
...

Thank you Ron & Andrew for very useful info.

Just a small sub-question:
How can I get the list of functions added by ATPVBAEN.XLA?

Bruno