WPS Record New Macro on Windows records your actions as JS macro code or VBA macro code for repetitive tasks; this guide covers 3 core tasks, with 3 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 3 | Matches the number of rows in the How-to Index |
| Available without membership | 3 | Matches the number of Free rows in the index |
| Membership-related items | 0 | Matches the number of membership-related rows in the index |
About This Feature
Overview
Record New Macro is an automation feature in WPS Docs for Windows that records a sequence of actions as JS macro code or VBA macro code so you can repeat the same workflow more efficiently. This guide also helps users looking for how to record a macro in WPS on Windows.
Core capabilities include:
- Record a new macro to capture your current actions.
- Choose where to save the macro in the current document or in all documents.
- Stop recording and continue with later editing from the macro management entry.
This feature is useful for repeated formatting, routine document processing, and other repetitive office tasks.
System Requirements
| Item | Requirement |
|---|---|
| OS | A Windows device |
| App version | It is recommended to use the latest version of WPS Office |
| Network | No mandatory network connection is required for local macro recording and playback |
| Other | VBA macros require the VBA plug-in on Windows; JS macros are supported on Windows and Mac, while mobile platforms are not supported |
Download & Installation
| Item | Details |
|---|---|
| Official Download | WPS Office Free Download |
| Post-install Check | Open WPS Docs, go to Tools and then Developer, and confirm that the Record New Macro entry is available |
Source: WPS download center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | Records actions in WPS Docs and can generate JS macro code or VBA macro code, with save options for the current document or all documents. | Word can record macros, store them in Normal.dotm for use in new documents, and run them with a button or keyboard shortcut. | Google Sheets can record macros and create Apps Script, but this workflow is designed for spreadsheets rather than document editing. | Notion provides button-based automation for pages, databases, and notifications instead of recorder-style macros inside a document editor. | Acrobat Pro provides guided actions that combine multiple PDF processing steps into a reusable action for batch work. |
| WPS Advantages | Advantage: WPS focuses on document editing workflows and supports both JS macro code and VBA macro code from the recording entry. | Compared with WPS: Microsoft focuses on Word macro recording and VBA workflows, and the official page does not describe JS macro recording. | Compared with WPS: Google macro recording is centered on Google Sheets, so its scope is spreadsheet automation. | Compared with WPS: Notion emphasizes button and workspace automation rather than recording editing steps as macro code. | Compared with WPS: Adobe focuses on PDF action sequences instead of a document-writing macro recorder. |
| Official Source | — | Create or run a macro | Automate tasks in Google Sheets | Buttons | Use guided actions (Acrobat Pro) |
Overall Conclusion
If you need to record and repeat editing steps inside a document workflow, WPS Record New Macro is closer to that use case. The other products also provide automation, but they are more focused on Word macros, spreadsheet macros, workspace buttons, or PDF batch actions.
Use Cases
| # | Scenario | Target Users | Core Pain Point | Solution |
|---|---|---|---|---|
| 1 | Repeated document formatting | Administrative staff, office users | The same formatting steps must be repeated many times | Record the workflow once and run the macro again when needed |
| 2 | Standardized file processing | Teachers, students, office workers | Multiple files need the same processing steps | Save a recorded macro and reuse it across similar tasks |
| 3 | Routine template cleanup | General users | The same commands are clicked again and again | Use Record New Macro to reduce repeated manual work |
| 4 | Team document standardization | Team members | Processing steps vary from person to person | Record a consistent workflow and reuse it |
| 5 | Macro learning for beginners | New macro users | Writing code manually is difficult at the beginning | Record actions first, then review and edit the macro |
Membership & Benefits
Free vs WPS Premium
| Feature | Free User | WPS Member |
|---|---|---|
| Record New Macro | ✅ Available | ✅ Available |
| Basic Office features | ✅ Available | ✅ Available |
| Cloud storage | 1 GB | 20 GB |
| Templates and extended benefits | Limited downloads | More templates and extended benefits |
Source: WPS Office pricing page
Recommendations
| Use Case | Recommended Plan | Reason |
|---|---|---|
| Occasional macro recording and playback | Free version | Record New Macro itself is available without membership |
| More cloud storage and broader office benefits | WPS Member | Suitable if you also need storage, templates, and additional office benefits |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page