WorkSheet Function

[Deepthiv]

i am using Excel Object API in VB.NET

Dim X1 As Object

X1 = CreateObject("Excel.Application")

Dim res As Double = X1.WorkSheetFunction.Percentile(dblData,p)

here is dblData is array of type double which has recordset column values,

There is an exception saying. "Unable to get the Percentile property of the WorksheetFunction class"

i have added "Microsoft Excel 9.0 Object Library"

am i missing anything? Can some one please help

Regards,
Deepthi