Hi,

I want to generate a Report in Excel from ASP page.

I am using Response.ContentType = "application/vnd.ms-excel" for generating an Excel file.

But the problem I cannot put any dynamic data in the Excel sheet. Actually I find VBScript is not at all working when I use the specified ContentType.

May I have some help on it with code example.

check out http://www.greggriffiths.org/webdev/both/excel/ which covers this topic.