Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
WRQ Reflections VBA help - Importing a text file
After some more tweaking, that works just perfectly. Thanks a million.- JWishbone
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
WRQ Reflections VBA help - Importing a text file
I'm game for whatever will work. How would I get it to read each line? There are 4 lines in the text file. I saw <object>.ReadLine in the VBA help, but there were no examples and I don't understand how it works. How do I tell it to read in each line? Here is all that was in the help file...- JWishbone
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
WRQ Reflections VBA help - Importing a text file
To all, I am a programming novice who needs some help importing a multi-line text file and outputting it. The text file looks like this: LIST CAR-INV WITH STATUS EQ "S" AND WITH I-ACCT NE "12345""23456""34567""45678""56789""98765""87654""76543""65432""" DAYS COLOR I-ACCT MAKE MILES MODEL...- JWishbone
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
