I'm trying to call the XIRR function on my VB.NET project but it's not listed in the available options. I have made a reference to Microsoft Excel 11.0 Object Library but it seems like I need a newer version or some other reference. If you look at my code below I can access the IRR function but not XIRR. Thanks for your help!
Protected Sub btnSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.Click
Dim oXL As New Excel.Application
Dim result As Double = oXL.WorksheetFunction.Irr(Cash, 0.1)