Running Access Macros via a Web Site

I have an Access 97 database running on an IIS Intranet server. I am using ASP to run SQL queries via HTML web pages. I have an Access Macro which I use to export the database to an Excel spreadsheet but I have to run this on a local saved copy of the database. Can this extract facility be offered to users with a browser so they can save an Excel version of the database while on line. I have read about the VB command DoCmd.TransferSpreadsheet but not sure if this is the best route. Anyone have any code ?