Topic: Generate Excel from ASP (Page 1 of 1) Pages that link to <a href="" title="Pages that link to Topic: Generate Excel from ASP (Page 1 of 1)" rel="nofollow" >Topic: Generate Excel from ASP <span class="small">(Page 1 of 1)</span>\

Neurotic (0) Inmate
Newly admitted

Insane since: Sep 2004

IP logged posted posted 09-16-2004 04:13 Edit Quote

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)

Post Reply
Your User Name:
Your Password:
Login Options: Remember Me On This Computer
Your Text:
Options: Show Signature
Enable Slimies
Enable Linkwords

« BackwardsOnwards »

Show Forum Drop Down Menu