Re: I need more speed Baby!
Hey? What? No takers?
Brewguru99
Re: I need more speed Baby!
The answer is - it depends. Single InStr can be a bit faster, but reading big file in memory can cause swapping, so it can be slower.
I think grouping files is not good idea.
Re: I need more speed Baby!
In addition to Bruno's post - you'll also find that using the VB 'Like' command is a lot quicker to see if a text string contains the text you're looking for than using InStr (although it only tells you if it's there, it won't give you a position in the text so you'll still need InStr).
Chris Eastwood
CodeGuru - the website for developers
http://codeguru.developer.com/vb
Re: I need more speed Baby!
Hey, excellent Tip. We VBers need more speed with strings and every Tip is welcome.
"Like" works great with case-insensitive searches - Instr is slow when vbTextCompare option is used.