Excel to CSV

[Swaroon]

Hi,
I have an excel file and cells A1 to A3 look like

"data1" "data2" "data3" etc if cell is empty then it shows as ""

When I save the excel as a CSV file, and open in Notepad, I get

"""data1""","""data2""","""data3""", etc if cell is empty then it shows as """"""

But I want

"data1","data2","data3", etc if cell is empty then it shows as ""

The "" are added to the data in each cell in a range by means of a macro - can i remove the macro and use a file format to ge tthe required result ?
What am I doing wrong ?
thanks
Steve

 

[Andrew Poulsom]

Sorry, I don't understand. Your data should be contiguous starting in A1. The CurrentRegion property returns a range bounded by blank rows and columns. For this data it would be A1:D4:

A1</SPAN>
A2</SPAN>	B2</SPAN>	C2</SPAN>	D2</SPAN>
A3</SPAN>	B3</SPAN>
A4</SPAN>

<TBODY>
</TBODY>

It doesn't matter if some cells are blank provided that all cells in a column or row aren't blank. A csv created from that will have 4 rows and 4 columns.

 

[Swaroon]

Thanks for your help on this - I'll recheck all
thanks