Generate Excel File Using ASP

Hi experts,

With response.contenttype = "application/vnd.ms-excel", I can easily export
my data to Excel which is embeded and shown within a browser.

If I'm going to save the Excel file through ASP programming, which method
can I use? I need to save the data to Excel file with dynamic name (the file
name should contain key values and appended with system datetime).

Thanks a lot

"LBT" <LBT@discussions.microsoft.com> wrote in message
news:939C2D4C-0AA3-4814-8B19-B980D9EF4FA9@microsoft.com...
> Hi experts,
>
> With response.contenttype = "application/vnd.ms-excel", I can easily
export
> my data to Excel which is embeded and shown within a browser.
>
> If I'm going to save the Excel file through ASP programming, which method
> can I use? I need to save the data to Excel file with dynamic name (the
file
> name should contain key values and appended with system datetime).

Use this method, but add some variables in the filename as appropriate:
http://www.aspfaq.com/show.asp?id=2129

--
Tom Kaminski IIS MVP
http://www.microsoft.com/windowsser...ty/centers/iis/
http://mvp.support.microsoft.com/
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS

For FSO code to create an Excel file to be stored on the server:

Creating the Excel File Server Side
http://www.greggriffiths.org/webdev...serverside.html

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Developersdex http://www.examnotes.net ***