Problem in export data to Excel

[PrakashN]

I used excel to export data(Customer Name,Address). In form i used Multiline property 'Yes' for address. So it shows a small square box for each end of line in excel. how can avoid this square box..

[QVeen72]

Hi,

How you are Exporting to Excel, may be you can Replace the String and Export
some thing like this :


Excel.Cells(2,3 ).Value = Replace(RS("MyF ieldName"), vbCrLF,"")

REgards
Veena

[PrakashN]

Hi,

How you are Exporting to Excel, may be you can Replace the String and Export
some thing like this :


Excel.Cells(2,3 ).Value = Replace(RS("MyF ieldName"), vbCrLF,"")

REgards
Veena

It's working..
thank you very much..