XIRR Function retruns an error object

S

Sai Krishnakumar

I have been using OWC10.Spreadsheet Analysis Toolpak (correlations,
regressions etc) functions in my code without any problems until now.

The following code snippet returns an error object -

QRS.Cells(k+2,2) = "=XIRR(B1:B" & k+1 & ",A1:A" & k+1 & ")*100"
RPTXR = QRS.Cells(k+2,2).Value
Response.Write TypeName(RPTXR)

I have tried exporting the spreadsheet. The XIRR calculation result appears
correctly in the cell on the excel sheet. Iam just unable to access it from
code.

Does it have something to do with initializing the Toolpak add-in ?? If so
how come other Toolpak functions work fine ? And how do I go about
initializing it using the .Addin method ? (MSKB doesn't show any examples)
 

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

XIRR #NAME? error - Toolpak IS installed 1
Excel XIRR function in Access 2007 VBA causes run-time error 0
Compile error when accessing a spreadsheet 1
Out of context error in user defined function 0
using a function in an addin in my vba code 2
TRIM Function gives Compiler Error!!!! 6
VB won't recognize function in Analysis Tool Pak 1
Can you use the offset property with OWC10 spreadsheet object? 1

Top