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
-- 
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Craig" <Craig@discussions.microsoft.com> wrote in message 
news:86B4F703-3067-48E7-9F7A-76B4362B8B01@microsoft.com...
> 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?