I have added Export To Excel button in an asp page (classic asp). Whenever a report asp page (say report.asp) is displayed and the user clicks Export to Excel button, the source HTML (viewable through View-Source in Internet Explorer) of report.asp is copied in a text file say export.txt. Then through asp/vbscript code, this file is renamed as export.xls. When the user opens this export.xls in Excel, Excel reads this HTML and shows the exact copy of report.asp report page in Excel (not just an image but properly formatted report).
The issue that I am facing is that on my report.asp page, there are two buttons; Back to Menu and Export To Excel. Since the whole HTML is copied in text file, so the code for these two buttons is also included. In Excel export.xls, when I click these buttons, nothing happens. I am unable to delete these two buttons. For example, when I select the button Export To Excel (shown at the end of the report) and press Delete, it is not deleted. When I right-click it, no pop-up menu is shown.
My users will be contented as long as I can tell them any way to delete these two buttons from export.xls
The issue that I am facing is that on my report.asp page, there are two buttons; Back to Menu and Export To Excel. Since the whole HTML is copied in text file, so the code for these two buttons is also included. In Excel export.xls, when I click these buttons, nothing happens. I am unable to delete these two buttons. For example, when I select the button Export To Excel (shown at the end of the report) and press Delete, it is not deleted. When I right-click it, no pop-up menu is shown.
My users will be contented as long as I can tell them any way to delete these two buttons from export.xls