View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Salmec Salmec is offline
external usenet poster
 
Posts: 2
Default VBA Read-Manipulate-Save Text File

Hi to all,
i've a text file with more than 6.000.000 rows, i've to read the file, manipulate some rows and save the new file.

I'm doing in this way but the elaboration time is about 4 minutes:
-First I open the file for input and i count the Rows
- I close the file and open another time reading each line and put it in an String array
- While I read I manipulate the data
- Open another file in Output mode and Write all the array in the file.

Does exist an efficient mode to do what i would like to do?

Thanks in advance

Salmec