break line in text cell from ASP

[Lorenzo]

hi to all, sorry for my little little english.

i wont to export in excel from sql by asp

if in a field there is a chr(13), excel send to new row the text. What i do
to tell excel go in a new line in the same cell?

i try so but don't work:

strXls = strXls & replace(fld.value,vbCrLf,Chr(10))

many thanks

Lorenzo

 

[Dave Peterson]

I don't speak the ASP, but maybe....

strXls = strXls & replace(fld.value,vbCr,vblf)

or

strXls = strXls & replace(fld.value,char(13),Chr(10))

Without knowing what strXLS or fld.value is, either.

 

[Lorenzo]

Thank You!
Unfortunately in the same case excel break text cel in a new row.

Without knowing what strXLS or fld.value is, either.

strXls, is a variable that contain the output in excel
fld.value, is the value of a field of db that can contain some break line
and i must send it in a unique cel

sorry again for my english

Lorenzo

 

[Dave Peterson]

How are you sending that value to excel?

If you're just plopping that value into the cell, I would think it would work
ok:

xlApp.workbooks("someworkbook").worksheets("someworksheet").range("a1").value _
= strXls

If you're relying on windows pasting the value, then maybe you could substitute
a different (unique) string (|) and then change that to alt-enter (char(10)).

 

[Tim Williams]

How are you exporting to Excel ?

As tab-delimited, as HTML table, via Excel automation.... ?

 

[Lorenzo]

As tab-delimited

 

[Lorenzo]

How are you sending that value to excel?

I build an xls file as tab-delimited

If you're relying on windows pasting the value, then maybe you could
substitute
a different (unique) string (|) and then change that to alt-enter
(char(10)).

i can't sobstitute after file creation, it is send to web client

 

[Dave Peterson]

If you're building a tab delimited file, then I think you're going to have to
find a different way.

Excel will see those alt-enters as new lines and import that data into a new
row.

 

[Lorenzo]

Ok. Thank you for your answers and your patience.

bye
Lorenzo