Hi folks,

I am maintaining a program which reads through a pre-prepared CSV file using Input #. The first line of the CSV file contains field names, one of which has recently been changed from "Protection Type" to "1st Protection Type". For some reason VBA simply returns the number 1 instead of the full string.

I find this strange, since within the subsequent data lines there are many alphanumeric fields which begin with numbers and they are all read correctly.

Before I start making wholesale changes to the software (plan is to either use Line Input # and parse each line manually, or import the entire CSV file and move the data using an array) does anyone know if there is a way around this behaviour?

Cheers