Run Macro in WPS on Windows: Introduction

Run Macro in WPS on Windows lets you execute existing JS macro code and VBA macro code for document automation; this guide covers 1 core task, with 1 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	1	Matches the number of rows in the How-to Index
Available without membership	1	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index
Version limitation	Windows supports VBA macros	VBA macros are not supported on Mac

About This Feature

Overview

Run Macro is an automation feature in WPS Writer that lets you run existing JS macro code or VBA macro code to complete repeated document tasks more efficiently.

Core capabilities include:

Run an existing macro directly from the Run Macro dialog.
Support two macro types: JS macro code and VBA macro code.
Reduce repeated manual work in document processing.

Typical use cases include batch formatting, repeated content insertion, and fixed document processing workflows.

System Requirements

Item	Requirement
Operating system	Windows desktop environment
App version	It is recommended to use the latest version of WPS Office
Network	No mandatory internet connection is required for local macro execution
Other	Open the document in WPS Writer; use Windows if you need to run VBA macros

Download & Installation

Item	Details
Official download	WPS Office Free Download
Installation notes	Download and install the WPS Office Windows client, then open WPS Writer to access the related entry points
Post-install check	Open a document, then go to Tools and Developer Tools to confirm that the Run Macro button is available

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	WPS Writer can run existing JS macro code and VBA macro code to automate preset document operations.	Word can create, record, and run macros from a button, keyboard shortcut, or the macro list for desktop document automation.	Google Workspace macros are available in Google Sheets, where recorded actions are converted into Apps Script and played back automatically.	Notion buttons automate page, database, notification, and related workspace actions with one click.	Acrobat guided actions can run one or more commands across multiple PDF files with a single click.
WPS Advantages	Advantage: WPS focuses on running existing document macros directly from the interface in a writing workflow, including JS macros and Windows VBA macros.	Compared with WPS: Word provides a broader macro recording workflow, while WPS centers this feature on directly running existing macros in WPS Writer.	Compared with WPS: Google's macro workflow is centered on Sheets rather than word-processing documents.	Compared with WPS: Notion automation is designed for workspace workflows and database actions rather than document macro code execution.	Compared with WPS: Adobe automation is oriented toward PDF batch processing instead of word-processing macro execution.
Official Source	—	Create or run a macro	Google Workspace macros and Apps Script	Buttons	Guided actions

Overall Conclusion: If your main task is to run existing macros inside a word-processing document, WPS provides a direct entry point in WPS Writer. Other products also offer automation, but they focus more on Word macro workflows, spreadsheet automation, workspace actions, or PDF batch processing.

Use Cases

No.	Scenario	Suitable for	Main pain point	How it helps
1	Batch formatting	Administrative staff and office users	Repeatedly adjusting headings, paragraphs, and fonts takes time	Run a preset macro to complete formatting automatically
2	Template-based insertion	Office users	The same document flow requires repeated content insertion	Use a macro to perform fixed insertion and layout steps
3	Document workflow automation	Team members	Repeating multiple steps manually can cause errors	Run a macro to complete steps in a preset order
4	VBA-based document processing	Users familiar with VBA	Existing VBA scripts need to be reused in documents	Select and run a VBA macro directly on Windows
5	JS macro execution	Users who rely on scripting	Manual script-based operations are inefficient	Select a JS macro in the Run Macro window and execute it

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Run Macro entry	Available	Available
Basic office editing	Available	Available
Additional premium benefits	See current plan details	See current plan details

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
You only need to run existing macros	Free	The Run Macro feature is available without a membership requirement
You also need more advanced office benefits	WPS Premium	Suitable if you want additional premium features beyond macro execution

WPS membership center: Subscribe now