Save As CSV (XL97:SR2)

When I save a worksheet as a CSV file I get one additional line of data. If one were to open the CSV file in XL, the last row is blank. However if you open the CSV file in Word or a text editor program you see the additional row.

Re: Save As CSV (XL97:SR2)

<img src=/S/hello.gif border=0 alt=hello width=25 height=29> jstevens

I think MS-Excel is putting this extra line as an End-Of-File marker. I maybe mistaken, it could be done by the CSV routine in MS-Excel, or the program you are using to open it, such as MS-Word, try and use NotePad, or what have you.

Try and open it back into MS-Excel and see if this line gets read.

Try to make sure that you don't have any "dirty" cells below your data range. Dirty cells are used cells that now are cleared from what they held before.

There is a MSKB article about finding or resetting the Last Cell, see if this helps in making sure that you are ONLY saving what you really want to save.