redirect page After writing out response in excel
Posted on 2008-10-23
I have a html file containing a form that allows user to enter start date and end date that are relevant for retrieiving a recordset. When the user click on the submit button on the form, a wait message will be displayed and then the data is submitted to an ASP page that process the request by querying the database using the supplied parameters of dates. In that ASP page the response contenttype has been changed to application/vnd.ms-excel so that the recordset can be written out in excel format. As a result, a diaglog box always appears asking user if they want to save/open the file (or cancel the transaction). However, when the diaglog box appears, the browser is still showing the wait message of the html file that calls the ASP page. Is there anyway to redirect the page after the save diaglog box appears so that the user won't see the wait message any longer?