Excel Functions in VB.net help

So, I'm trying to use the Linest function from Excel and I'm trying to implement it into my code. After trying many different ways, this is what I've currently done.

First, I added the Excel Interop to my project resources.

Then I tried this code:

Code:

---

Imports Microsoft.Office.Interop.Excel

Dim xl As Microsoft.Office.Interop.Excel.Application
Results = xl.WorksheetFunction.LinEst({1,2,3,4}, {5,6,7,8})

---

I get the following error:

Quote:

---

Object reference not set to an instance of an object.

---

I changed it so I was setting xl as a NEW application instance with the code below:

Code:

---

Imports Microsoft.Office.Interop.Excel

Dim xl As New Microsoft.Office.Interop.Excel.Application
Results = xl.WorksheetFunction.LinEst({1,2,3,4}, {5,6,7,8})

---

I then got the following error:

Quote:

---

Unable to cast object of type 'System.Object[*]' to type 'System.Object[]'.

---

I've tried many variations but, sadly, this is as close as I seem to be able to get (I imagine it's probably a pretty simple mistake of creating the correct instances and calling them correctly but, for the life of me, I can't seem to find out where to go from here so I figured I'd check with the experts. But I don't have the money for that so I came to you guys instead. :D

Any help you can give me would be GREATLY appreciated. Thanks!

Oops, left out a line.

Code:

---

Imports Microsoft.Office.Interop.Excel

Dim xl As New Microsoft.Office.Interop.Excel.Application

Dim Results() As Object
Results = xl.WorksheetFunction.LinEst({1,2,3,4}, {5,6,7,8})

---

Is it possible the issue has to do with the linest function returning something that can't be stored as an object?

Nevermind. Fixed the issue.