Office Settings & Configuration

Automate Excel Add-in Actions When Office Scripts Cannot Record Them

Amos GikundaAmos Gikunda Nov 13, 2026 869 views

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.

Automate Excel Add-in Actions When Office Scripts Cannot Record Them
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the add-in documentation

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'.

2
Identify the supported automation method

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.

3
Call the automation method from an Office Script or flow

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.

Use the Excel Add-in's Own API or Automation Interface
Why the recorder did not capture add-in clicks: Office Scripts records workbook operations only. Add-in task panes, dialogs, and ribbon controls run outside the recorder scope, so those actions require an API or connector.
Free Microsoft Office alternative

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. 1. Download and install WPS Office: Go to the WPS Office download page and install WPS Office on your device.
  2. 2. Open your Excel file in WPS Spreadsheets: Launch WPS Spreadsheets, select File > Open, and choose your existing .xlsx workbook.
  3. 3. Use macros for workbook automation: Open the Developer tab in WPS Spreadsheets and use the macro tools to automate repeated workbook tasks.
Opens and saves .xlsx Microsoft Excel files without format conversion, keeping formulas and data intact.Free and lightweight Office suite with WPS Spreadsheets, Writer, and Presentation.Familiar ribbon interface makes it easy to switch from Microsoft Excel.Supports macro-based workbook automation so you can handle repetitive spreadsheet tasks.Seamless migration from Excel, with PDF and cloud integration built in.
QA img-9

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.