Hello,

I have some data in a text file that I would like to import. Unfortunately,
it's not in CSV format. I was wondering if it's possible in VBA to open
this file, read in a line, and parse the line as I need, and then write the
line (cells) to a spreadsheet. Or should I just write a file pre-processor
(which generates a CSV file) in Java, C, whatever, and import the data.

I'm not a VBA expert, so I don't know the limitations.

Any help would be appreciated.

Regards,

Alan