Topic: Generate Excel from ASP (Page 1 of 1)

I want to create an Excel object from an ASP page. Basically, the input parameters to the Excel would be from the ASP. I know ASP and I know VBA, but I haven't used both of them together. Here's what I would like to do -
The ASP should generate an Excel report by passing 2 parameters to the Excel application (I have done this independently; without interfacing with ASP).

I know that I can create an excel handle from the ASP as -

Set MyExcel = Server.CreateObject("Excel.Application")

I dont know where the VBA code has to go? DO I have to include it in the ASP? (I hope my talk makes sense)