Reading a text file
I am building a converstion tool to convert a csv to a qif file.
Problem is in the reading loop.
Open "C:\Documents and Settings\LLAL\Desktop\" & File1.FileName For Input As #1
Do While Not EOF(1)
Input #1, Datum, Begunstigde, Rekening, Tegenrekening, Code, AfBij, Bedrag, Boekingstype, Memo
Loop
Close #1
I am getting a runtime error 62 (input past end of file) because my bank institution puts an extra Ascii 10 code at the end of the file.
Can someone tell me how to eliminate that last character in my inputfile? If I delete it by hand the loop works.
Who can help?
Thanks,
Jack

