Microsoft Excel - calling an excel macro from aspx page

I want to call an excel macro from aspx page to create the cutomized excel reports.

any help.

thnx in advance

Use Microsoft.Office.Interop assembly to call the macro function in the underlying excel.

For e.g. "mac" is the macro name, and 32 is the value being passed to that macro in the following example. xlApp.Run("mac","32")

For futhure reference, use the following urls:

http://en.allexperts.com/q/Excel-1059/Excel-Macro-C-VB.htm

_mExcelApp = new Excel.Application();

if (_mExcelApp == null)

throw (new Exception("Unable to Start Microsoft Excel."));

//_mstrXLSFileFullName = XLSFileFullName;

_mExcelApp.Visible = true;

// _mExcelApp.WindowState = Excel.XlWindowState.xlMinimized;

_mWorkbook = _mExcelApp.Workbooks.Open(XLSFileFullName, Type.Missing,

Type.Missing,

Type.Missing,

Type.Missing, Type.Missing,

Type.Missing,

Type.Missing,

Type.Missing, Type.Missing,

Type.Missing,

Type.Missing, Type.Missing,

Type.Missing, Type.Missing);

_mWorkSheet = (Excel.Worksheet)_mWorkbook.Worksheets.Application.ActiveSheet;

//_mWorkSheet.Name = _mstrWorkSheetName;

//_mExcelApp.SheetsInNewWorkbook = 1;

Just use this code

RunMacro(oAccess, new object[] { "InsertData" });