Find a string in a text file Fast....

[Merri]

If you are reading files that big you may wish to consider using some level of buffering instead of reading the whole file to memory at once.

[Liquid Metal]

If you are reading files that big you may wish to consider using some level of buffering instead of reading the whole file to memory at once.

Agree but can your code still be applied? It seems that your api opens the whole file at once.

Is it similar to this one:
http://www.vbforums.com/showpost.php...0&postcount=12

If yes, can you help me clean it up? I would really appreciate your help on this.

[Liquid Metal]

Hi Merri, I got your code to work on big files. It does run faster then any of the other method but there is a memory leak.

If you run it in Excel VBA, you can seek the memory keeps accumulating in the task manager.