What I use: An app where following procedure has to be run approx 100.000 times... it takes 5 minutes! It should go faster.
Question=how?
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
Clipboard.SetText(Record.ToString)
Range = EXCBook.Worksheets(Page).cells(Row, 1)
EXCBook.Worksheets(Blad).Paste()
Software/Hardware used: vb studio 2005 & excel 2003
...following procedure has to be run approx 100.000 times... it takes 5 minutes!
Does that mean that you expect to invoke and run that code more than 333 times per second?
Can you describe the environment? What is it running on? How is it called?
Tom
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!
Discuss This Question: 3  Replies