export recordset

[emissions]

i have generated a table recordset in web page using asp code. i need to take this step further, and when the user click's a button to export to excel the report(recordset) in the web page should automatically export to excel file and it should save itself with filename having currentdate as like "141105.xls" within a specified directory.

One thing it shud not prompt the user to give the file name to save in excel.

i have used
Response.ContentType = "application/vnd.ms-excel"
but system prompting user to enter the file name to save the file in excel.

thanks advanced

 

[Cheech]

Try rereading your question.

I want to create a file on my users PC that they have no control over what it is called or where it is saved. This file could contain macros that could be virus' or exploits..

Hmm I wonder why this is protected against. Once the user has the file on PC they can rename it to whatever they want even if it is readonly.

[Peace][Pipe]