How can I run excel macro from asp.net web form

Hi...
How can I run an excel macro from asp.net? I could able run the same macro from .net windows form, but could not able to run from asp.net web form. I dont get any error messages too.

Any help is apprecited.

Thank you

Jags

Welcome to the forum.

What code have you tried? Are you opening the Excel file and then using something like xlApp.Run "mymacroname"?

Hi Helen,
Thanks for the reply.
This is the code I am trying,same code works well with windows form.


Dim oExcel As New Excel.ApplicationClass
Dim oBook As Excel.WorkbookClass
Dim oBooks As Excel.Workbooks



'Start Excel and open the workbook.
oExcel = Server.CreateObject("Excel.Application")

oExcel.Visible = True


oBooks = oExcel.Workbooks
oBook = oBooks.Open("c:\temp\Book1.xls")


'Run the macros.

oExcel.Run("test")

'Clean-up: Close the workbook and quit Excel.
oBook.Close(False)
System.Runtime.InteropServices.Marshal.ReleaseComObject(oBook)
oBook = Nothing
System.Runtime.InteropServices.Marshal.ReleaseComObject(oBooks)
oBooks = Nothing
oExcel.Quit()
System.Runtime.InteropServices.Marshal.ReleaseComObject(oExcel)

oExcel = Nothing
GC.Collect()



Thanks & any help is appreciated.

Jags