What I use: An app where following procedure has to be run approx 100.000 times... it takes 5 minutes! It should go faster.
Dim Record as string
Dim oExcel As Microsoft.Office.Interop.Excel.Application
Dim EXCBook As Object, Range as object
oExcel = New Microsoft.Office.Interop.Excel.Application
EXCBook = oExcel.Workbooks.Open(TxtFolder.Text & "FBL.xlt")
Record = strLine & vbTab & strSort & vbTab & Date 'sets the values for column 1, 2 & 3 in the Row
Range = EXCBook.Worksheets(Page).cells(Row, 1)
Software/Hardware used: vb studio 2005 & excel 2003
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!