I tried the code below,but it doesn't seem to faster
thanks for your reply all the same


VB Code:
  1. Option Explicit
  2. Dim time
  3. Dim time1
  4. Private Sub Form_Load()
  5. Call now_time
  6. Dim i, j As Integer
  7. Dim mydata1(10000)
  8.  
  9.  
  10.   'load file and put the data in to MSFlexGrid1
  11.   i = 0
  12.   Open App.Path & "\1.dat" For Input As #1
  13.   Do While Not EOF(1)
  14.     Line Input #1, mydata1(i)
  15.     i = i + 1
  16.   Loop
  17.  
  18. MSFlexGrid1.Rows = 1
  19. For j = 0 To i
  20.    MSFlexGrid1.AddItem Replace(mydata1(j), ",", vbTab)
  21. Next
  22.  
  23. Call now_time1
  24.  
  25. MsgBox Second(time1 - time)
  26. End Sub
  27.  
  28.  
  29. Private Sub now_time()
  30. time = Now()
  31. End Sub
  32.  
  33. Private Sub now_time1()
  34. time1 = Now()
  35. End Sub