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