I am trying to populate an array from data in an opened EXCEL file and can't get it to work. I need to populate a 2 dimensional array from Range("G7:H700"), for example. I did not include any code here since I have tried many ways and all have raised errors. Would someone please offer a solution? I prefer not to have to loop thru the cells one by one. I would like to pass the entire range into the array in one pass. Thanks
This is how I am creating an instance of EXCEL in VB.NET
Dim xl As Object
Dim wrkbk As Object
Dim wrksht As Object
xl = CreateObject("Excel.Application")
wrkbk = xl.Workbooks.Open(Filename)
wrksht = wrkbk.Sheets(1)
This is how I am creating an instance of EXCEL in VB.NET
Dim xl As Object
Dim wrkbk As Object
Dim wrksht As Object
xl = CreateObject("Excel.Application")
wrkbk = xl.Workbooks.Open(Filename)
wrksht = wrkbk.Sheets(1)