Excel Macro Runner is a lightweight yet powerful Integration Studio extension that enables OutSystems applications to invoke VBA macros stored in Excel workbooks (.xlsm) directly from the server side. This component bridges modern web applications with legacy Excel automation by providing seamless control over Excel's macro execution engine.

This is especially useful when complex business logic or reporting processes are still encapsulated in VBA macros and rewriting them in another technology is not feasible.

Key Features

• Executes any macro from a macro-enabled Excel workbook.
• Supports passing dynamic parameters to the macro via a comma-separated string.
• Uses Microsoft Office Interop (Microsoft.Office.Interop.Excel) for native Excel automation.
• Automatically handles resource cleanup (closes workbooks, quits Excel, releases COM objects).
• Easy to configure and integrate into any OutSystems logic flow.