Hi all,
I'm working on a use case where we need to trigger a macro-enabled Excel workbook (.xlsm) on the user's local machine and execute it with parameters from the UI.
Use Case:
When the user clicks a button or link from the UI:
The application should open an Excel .xlsm file from a given URL (e.g., SharePoint)
The file should open in the user’s local Excel instance
It should pass two parameters: Premium and Rate
A macro inside the workbook should run automatically (triggered on workbook open)
Regards,
Sudharshan
Hi Sudharshan T,
Regarding your queries:
Point 1: Opening the Excel .xlsm file in the user’s local Excel instance
Since you are working with a Reactive Web App in OutSystems, when a user clicks a button or link, the .xlsm file can only be downloaded. Opening it directly in the local Excel application is not possible due to browser limitations. Browsers typically allow files to be downloaded, not opened directly in external applications like Excel.
Point 2: Automatically running a macro inside the workbook
OutSystems does not support the execution of macros within Excel files. Macro execution must be triggered manually by the user after opening the file in Excel on their system.