So, i have a macro i inherited.

It is pretty nuts in some of the assumptions it makes, and i don't want to recode it if i can help it.

One of the assumptions it makes is that a certain log file will parse a certain way. The openText call is as follows:

Workbooks.OpenText Filename:=DataPath & "\SUO890.rpt", Origin:= _
        xlWindows, StartRow:=1, DataType:=xlFixedWidth, FieldInfo:=Array(Array(0, _
        1), Array(33, 1), Array(34, 1), Array(38, 1), Array(55, 1), Array(79, 1), Array(83, 1), _
        Array(103, 1))
This log has unix style line breaks at the end of its lines. These consist of 2 0xA characters on each line.

We were originally running this in Excel 2003, but now we're porting this system over to new hardware and 2007 must be installed per license agreement.

So, in Excel 2003, the line feed described above leads to one line between each row in the Excel spreadsheet when it's imported using the above code.

HOWEVER, in Excel 2007, the same line break characters are causing 2 rows between each row when imported.

Is there a setting i can change or something i can add to make this change?

any help you can suggest is GREATLY appreciated.....