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