How to export xml to excel using ASP
i have a ASP page that searches for a particular field(eg. Author Name) in SQL2k and the search results will be written into this xml file called 'Results.xml' which will be transform with Results.xsl into the asp page to display to users.
This asp page will display the search results and on the page itself, there is an archive button such that when user clicks on 'Archive', there would be a file dialog box prompting user to select the path where they wanted to save the excel file into their local hard disk drive.
my problem is "how to get the filedialog box out and to export the 'Results.xml' into excel file(Results.xls)
I am using vbscript for this.