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

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

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

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

"Dave Peterson" ha scritto nel messaggio
...
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

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 wrote:

"Dave Peterson" ha scritto nel messaggio
...
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

How are you exporting to Excel ?

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

--
Tim Williams
Palo Alto, CA


"Lorenzo" <. wrote in message ...
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

As tab-delimited


"Tim Williams" <timjwilliams at gmail dot com ha scritto nel messaggio
...
How are you exporting to Excel ?

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

--
Tim Williams
Palo Alto, CA