Save as CSV not saving the same from Excel 2007 then in Excel 2003

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

If I take an Excel file and Save it as a CSV in Excel 2003 the blank rows
from the Excel file show up on the CSV as blank rows (no commas show in that
row)

But when I save the same file in Excel 2007 (which we recently upgraded) the
blank rows from Excel show up as about 15 commas on the CSV file. There are
also other rows of data in the CSV file that have 5-10 extra commas appended
to the end.

Is there an option in Excel 2007 to save as CSV file but exclude blank rows?
 
I can confirm that xl 2003 saves blank rows as blank rows while xl2007 saves
them with commas and seems to add a few rows at the end

In an experiment, I did a Data|Filter and deselected the blank rows, then
did Copy & Paste to new worksheet before saving a CSV. Empty rows are gone
as expected.

You could record a subroutine to do this
best wishes
 
Back
Top