Automate Excel Add-in Actions When Office Scripts Cannot Record Them
Question details
The user wants to know whether Office Scripts can record actions performed inside an Excel add-in and how to automate those add-in actions.

- Product
- Microsoft Excel / Office Scripts
- Device & OS
- not provided
- Scenario
- The user tried to record steps with Office Scripts while opening and clicking an Excel add-in, but no add-in actions were captured.
- Observed behavior
- Office Scripts recorded nothing when the user opened or clicked the add-in.
Confirm which Excel platform you are using: Office Scripts is available in Excel on the web and Microsoft 365, and the workbook must be stored on OneDrive or SharePoint. Before recording, open the add-in's documentation or settings to see whether it exposes an API, Power Automate connector, or built-in automation feature.
Use the Excel Add-in's Own API or Automation Interface
Use this when the add-in exposes a documented API, COM interface, webhook, or automation object. This is the most reliable way to automate add-in behavior without recording UI clicks.
Office Scripts records changes to the workbook, not clicks or controls inside an Excel add-in. If the add-in has a public automation interface, you can call that interface directly from Office Scripts, Power Automate, or an external script instead of replaying UI actions.
In Excel, open the add-in task pane or ribbon tab and look for a Help, Settings, or Developer menu. Open the official documentation and search for 'API', 'automation', 'COM', 'Power Automate', or 'Office Scripts integration'.
Check whether the add-in exposes a REST API, JavaScript/COM object, or connector. Note the endpoint, method names, authentication keys, or object model required.
In Excel on the web, select the Automate tab > New Script, then use fetch or the documented object to call the add-in API. If the add-in supports Power Automate, create a flow from Automate > Power Automate and add the add-in connector actions.

Automate the Add-in with Power Automate or a Connector
Use this if you do not need to record the add-in UI and the add-in offers a Power Automate connector or supported REST actions.
Check the Add-in's Built-in Automation or Batch Features
Use this for add-ins that include their own scheduler, batch processor, or macro-like recorder instead of relying on Office Scripts.
Use WPS Office as a Free Excel Alternative When Office Scripts Cannot Automate Add-ins
WPS Office is a free, lightweight Office alternative that opens, edits, and saves Excel .xlsx workbooks with a familiar ribbon and formula engine. While Microsoft Office Scripts cannot record add-in UI actions, WPS Spreadsheets gives you a compatible workspace for macros, data tasks, and everyday spreadsheet automation without a Microsoft 365 subscription.
- 1. Download and install WPS Office: Go to the WPS Office download page and install WPS Office on your device.
- 2. Open your Excel file in WPS Spreadsheets: Launch WPS Spreadsheets, select File > Open, and choose your existing .xlsx workbook.
- 3. Use macros for workbook automation: Open the Developer tab in WPS Spreadsheets and use the macro tools to automate repeated workbook tasks.

Frequently Asked Questions
Can Office Scripts record clicks inside an Excel add-in?
No. Office Scripts records workbook actions such as cell edits and formatting. It does not capture add-in task pane clicks, dialogs, or ribbon controls. Use the add-in's API or Power Automate connector instead.
How do I automate an Excel add-in if Office Scripts cannot record it?
Open the add-in's documentation from the Excel ribbon or task pane, enable its API or automation settings, then call those methods from an Office Script, Power Automate flow, or the add-in's own batch tool.
Does WPS Office support Excel add-ins or Office Scripts?
WPS Office does not include Microsoft Office Scripts. It opens and saves .xlsx workbooks and supports macro-based automation in WPS Spreadsheets, but third-party Excel add-ins may not be fully compatible.
What should I check before trying to automate an add-in?
Confirm that the add-in is loaded, the workbook is saved to OneDrive or SharePoint if you are using Office Scripts, and the add-in documentation lists an API, Power Automate connector, or built-in automation feature.




