Hello John,

Here is code which opens excel, writes 16,000 data points to Excel, Reads 16,000 data points from Excel, and populates a combobox with 16,000 points of data. Opening, writing, reading, and populating takes about 3.5 seconds. Here is code for this example:

[code] Dim excel as new ExcelApplication

Dim i as integer

Dim s as string

Dim r as ExcelRange

Dim StartTime as Double = Microseconds

//Create Data

For i = 1 to 16000

s = s + “A” + cstr(i) + “B” + EndOfLine.Windows

Next

//Copy to clipboard

Dim c as new Clipboard

c.SetText(s)

c.Close

//Paste from Clipboard to Excel

excel.Visible = true

excel.Workbooks.Add

r = excel.Range(“A1:A16000”)

r.Select_

excel.ActiveSheet.PasteSpecial(“Text”,false,false)

//MsgBox “16,000 datapoints added to excel”

//Clear the Clipboard

c.Text = “”

TextArea1.Text = c.Text

c.Close

//MsgBox “Clipboard cleared”

//Copy from Excel to Clipboard

excel.Range(“A1:A16000”).Copy

If c.TextAvailable then

TextArea1.Text = c.Text

End if

c.Close

//MsgBox “16,000 data points from Excel to clipboard”

//Put copied data into ComboBox

Dim Lines() as String

Lines = Split(TextArea1.Text, chr(13))

For i = 1 to UBound(Lines)

ComboBox1.AddRow Lines(i)

Next i

//MsgBox “16,000 data points added to Combobox”

Dim ThisTime as Double = Microseconds

MsgBox CStr((ThisTime-StartTime)/1000000) + " Seconds"

//Show elapsed time

Exception err

MsgBox err.message[/code]