ASP to Excel (2 issues)

[ElEye]

Greetings, Gurus:

I created an .ASP with this in it:
Response.ContentType = "application/vnd.ms-excel"

When running this page the Excel document succeeds if I select SAVE.

Problem 1:
The saved document creates a new row for each record AND for each carriage return within a memo field. I want each record on a new row, but how do I make the carriage return appear within the cell of the given memo field?

This is how I get the field to display with <BR>:
<%= replace(x_Description & &quot;&quot;,chr(10),&quot;<br>&quot %>

Without the replace function the memo field fills a single cell, but without any carriage returns.

Problem 2:
I'd like to use the OPEN option when the dialogue box comes up, but OPEN tries to open the document in Excel. I'd rather it opened in the browser - IE6.

A previous post on this subject without reply is found here: thread333-242935
----------
Thank you! Dave
[

http://flashspot.com

]

 

[ElEye]

FYI:

I was able to solve Problem 1. The Excel version of this .asp is based on a standard results page. The standard results page alternated row colors for readability. By removing the alternating row colors in the Excel version each record now correctly appears as a single row in the Excel version.

I'm still unable to solve Problem 2. Dave
[

http://flashspot.com

]