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("somewo rksheet").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)).



Lorenzo wrote:

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" ha scritto nel messaggio
...
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 wrote:

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

--

Dave Peterson