Export Data To Multiple Sheet

when user click a button data will be fetched from database based upon condition and it will be exported to multiple sheets of a single excel work book. what I am doing, onclick of button in main page, I am invoking a new asp page through document.location.href=test.asp.

In test.asp page created a instance of excel.applicaion and then fetching data from backend and putting data to different workbook cells of the the excel and at the end making excel.visible=true but the problem is excel file not getting visible on client machine.

But when I remove some server side code and put the rest of code inside vbscripting tag in the main asp page then the excel file becomes visible on client machine. I am not getting the where the problem lies in the first part .