calling excel function LinEst from VB

[jobxyz]

Hi

I am trying to call the excel function linest from VB using automation.

the call
Slope1 =
Excel.WorksheetFunction.Index(Excel.WorksheetFunct ion.LinEst(y, x),1)

works fine as long as x is a one dimensional array.

But I need to do regression analysis for a multidimensional array (e.g.
I have x1,x2,x3,...,xn independent variables in the regression.)

so when I define x as say
dim x (10,2) as double

I get an error messages
"unable to get the linest property of the worksheet function class"

anyone know how to use linest for a multidimensioanl array ?

Thanks

[Rich P]

One thing you could do is to run the function/Sub in Excel. You can
invoke the Excel Sub from Access remotely. XLobj.Application.Run
"SubLinEst". In your Excel Sub you write out the results of LinEst to
an Excel Sheet. Then read the results in the Excel Sheet from Access.
You can use ADO for that. Or you can use automation and read cell by
cell (if there are not a lot of cells).

Rich

*** Sent via Developersdex http://www.developersdex.com ***