Tottec


I have spent the day trying to figure this out and it is driving me nuts.

I have a large text file (2000+ lines) and I list of names in Excel. I need to search through the text file for each instance of each name. I have that working.

The problem I am having is that I can't figure out how to get back to to the top of the text file to search through it again. Currently I am closing and re-opening the text file for each name in the list. This is rather time consuming and I would like to be able to simply tell it to go back to the beginning of the file. I know how to do it in other languages but can't find the VBA equivalent of "go to x position" in the file.

Any help would be greatly appareciated.





Re: How to read the same text file repeatedly without having to re-open it each time?

Spidermans_DarkSide - MSP, VSIP


Hi,

This forum is for VB.Net questions only, not for VBA or VB6 ( or any earlier version).

Please see.>>

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=478161&SiteID=1

For VBA questions try. >>>>

http://www.programmersheaven.com/mb/vba/Board.aspx S=B20000

Regards,

S_DS