Hi all,
I m using below line in ASP page which i want to export:
<% Reponse.ContentType="appliation/vnd.ms-excel" %>
and using <table>..i m getting nice export utility.

The problem is that some users gets message from IE whether they want to open/save or cancel the file,(this is what i want so it is fine),but for some users it directly open an excel sheet in browser window and starts displaying data..and this is what i don't want to happen.

Assume that i m targeting only IE users.

Any suggestion? idea?


Rupen Anjaria.:)
------------------
We CAN'T avoid problems, but can solve it.

dear rupe,

all you have to do to make sure donwnloading begins, is add this to you code :
response.AddHeader "Content-Disposition", "attachment; filename=" & <addfilename here>

this is not working...if so where the file will be store? I want to ask user where he would like to store the file.

Rupen Anjaria.:)
------------------
We CAN'T avoid problems, but can solve it.

This is a configuration on the local machine and can NOT be controlled by the browser/webserver - as long as you server known supported MIME types as in your example. See http://support.microsoft.com/kb/q162059/ for more details on what you need to amend on the client machines for this to work.

Other options include providing an unknown MIME type, so they will always be prompted to download or ZIPping the contents and sending that back as a ZIP file.

This is covered in http://www.greggriffiths.org/webdev/both/excel/.

Great... Excellent!!!!! Thank you very much sir.

Rupen Anjaria.:)
------------------
We CAN'T avoid problems, but can solve it.

Hey Greg,
Right now, the exported file name is taken as .asp file's name, but my user wants to have file name something different, So, do u know any "know how" for this??
Thanks in advance.

Rupen Anjaria.:)
------------------
We CAN'T avoid problems, but can solve it.