hi,

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.

Check out http://www.greggriffiths.org/webdev/both/excel/ while it does not deal directly with using XML as the datasource, many of the exmaples and links could be altered to provide that functionality.

thanks a lot.
this site is useful and i have got it done