I am having issues commas in a row that is saved in csv format

[Darthzo]

I Created a macro that saves an excel file to CSV format this macro combines two reports into one. After the second report is added to the file there is a row of commas that is added in between both reports. I need to have this row of commas removed before I can send it to our back office to be processed could someone explain why I have this added row of commas. I was able to resave it in 2003 which would fix the problem now that the file is created using 2010 this solution is not working please help I added the file in excel as the forum doesn't allow csv files. Sorry I now added the Macro to this post.

[protonLeah]

Well, you didn't post your macro.
Hints:
1.? range("a1").CurrentRegion.Rows.Count returns 7 for the sample given, and
2. ?cells(rows.Count,1).end(xlup).row returns 11

Since the last row (11) is > the range A1 current region row, expect row 8 to be empty. Use
row("A"& x).entirerow.delete, where x=currentregion row count +1

[Darthzo]

Thank you protonLeah the issue is I need the line to separate the report just without the 5 commas that are generated from the macro.