Create CSV without extra Commas

Hi All,
JBeaucaire helped me to create a macro that will create csv files for each worksheet of a workbook.The Macro works great.

But i do have a requirement where i do not need extra commas (,) in the CSV. When the CSV are created for each worksheet, it adds additional commas in the end and my shell script throws it away becuase of the additional commas. Please help me modify the macro so that it does not add any commas for any cell which does not contain any value.

I have attached 3 files -
csvtest.xls - this has the macro which creates individual csv files for EACH worksheet in the workbook

Sheet1.csv - This is the CSV file created fromt he Macro. If you look into it, it contains additional commas in the end of each line

Sheet1_modified.csv - This is the output i expect from the Macro

Link to the thread in which JBeaucaire helped me to create this macro -

http://www.excelforum.com/excel-prog...v-files.html#2

Hello naveenkharb,

Excel creates a CSV file based on the UsedRange. This range includes cells that have borders, even if they are empty. If you can, reduce your borders to only column "F". If that is not an option then you need a different macro.

This may be a rough work-around, but I think you could open your csv in excel and save it as a csv of a different name. This would get rid of all commas after the last entry in the row with the most records. Would that solve your problem?

You could solve this in the data by not having all those extra cells formatted with boxes. That's what's causing the extra cells to be included.

Here's an amended version of the macro I wrote for you that should keep from having that problem.

NOTE: Feel free to leave the comments at the top of the macro there....

Please Login or Register  to view this content.