I hope that I can describe the situation clear enough.

So I have to write a user define function on VBA to extract relevant ‘columns’ and ‘rows’ from a text file without opening it. (Each line will contain some information and different type of info will be separated by ‘|’) I decided to use GetObject(text file) to read it, then I would use a for loop to do the extraction, but I don’t know how to write the first statement for the for loop (i.e. ‘for i in xxx’). Some help would be appreciated.

I actually have not yet tried anything because I don’t know how to proceed with the coding