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
|