boilerbdub

Here's the attached text file, I'm not sure if there's something in the file that is not allowing me to read the records one by one. Like I said before the macro is reading all of the record at once and putting ALL of them in one variable. Let me know if you can help. H8_CLASS4_PARTS_REPORT.TXT

Yes, I tried the File Read Begin Process and for some reason it saved the whole text file to the variable that it created. The lines in my text file are seperated by line breaks, and I tried seperating them with commas and it did the same thing. It just tried to save the whole file to one variable. Am I doing something wrong?

Here's the situation, I have a text file with about 1000 different serial numbers for parts. I need to find a way to have the macro get a value from the text file, output that value on the screen, then move to the next value in the text file. The serial numbers are on seperate lines in the text file. Is there anyway macro can do this? The closest thing I could find in macro was an option that allowed me to save the WHOLE text file to a variable and not one record from the text file. Any help would be greatly appreciated.