Counting Records from a pipe separated text file

Pipe separated text file means that there is one line (up to a carriage return line feed)? Take a look at the aqFile object. It has an OpenTextFile method. You can open the file, read the line and then



asSomeVar = Split(sWhateverYouReadIn, "|")





iNum = UBound(asSomeVar)