Interop Excel C#: Member not found. (Exception from HRESULT: 0x80020003 (DISP_E_MEMBERNOTFOUND))

Last Reply on May 25, 2016 02:34 AM By Shashikant

Posted on May 25, 2016 02:30 AM

i try to get lat and long values in excel 

there is a function in form1 

Public Function GetLine1() As List(Of PointLatLng)
        Return fparallelLines1
    End Function
    Public Function GetLine2() As List(Of PointLatLng)
        Return fParallelLines2
    End Function

 

i call these in form 2

now when i use these like this

oExcel = CreateObject("Excel.Application")
        oBook = oExcel.Workbooks.Add
        oSheet = oBook.Worksheets(1)
        parallelLines3 = clsTest.gmap.GetLine1()
        parallelLines4 = clsTest.gmap.GetLine2()
        oSheet.Range("A1").Value = parallelLines3
        oSheet.Range("B1").Value = parallelLines4
        
        'dgv_Search.Rows("Latitude").Value(, dgv_Search.Rows("Longitude").Value())
        oBook.SaveAs("C:\Book1.xls")
        oExcel.Quit()

 

this shows error

Member not found. (Exception from HRESULT: 0x80020003 (DISP_E_MEMBERNOTFOUND)) vvb.net

in this line

oSheet.Range("A1").Value = parallelLines3

how to solve this

You are viewing reply posted by: Shashikant on May 25, 2016 02:34 AM.