Switching VB/JS Macro Environment in WPS on Windows: Introduction

Switching VB/JS Macro Environment in WPS on Windows helps you choose the default macro development environment in WPS Writer; it includes 2 core tasks, with 2 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	2	Matches the number of rows in the How-to Index
Available without membership	2	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

Switching VB/JS Macro Environment is a macro development setting in WPS Writer for Windows. It lets you switch the default editing environment between VBA (VB macros) and JavaScript macros, so you can choose the development path that fits your document automation work.

Core tasks include:

Set the default JS development environment so WPS Macro Editor opens in the JS environment after restart.
Switch back to the VB environment from the developer tools area when you need to work with existing VBA macros.

This feature is useful for users who maintain document automation workflows, test different macro approaches, or move between existing VB macros and JS macros.

System Requirements

Item	Requirement
Operating system	Windows desktop environment
App version	Recommended to use the latest version of WPS Office
Network	No mandatory network connection is required for the environment switch itself
Other	VBA macros require the VBA plugin on Windows; documents that contain macros should be saved in a macro-enabled `.docm` format when needed

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	After opening WPS Writer, look for related macro environment entries in File > Options > View or Tools > Developer Tools

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	WPS Writer on Windows lets you switch between VBA (VB macro) and JS macro environments, and you can set JS as the default development environment.	Microsoft Word supports creating, recording, running, and writing macros in Visual Basic, with an official workflow centered on VBA macros.	Google Workspace macro guidance focuses on Google Sheets, where recorded macros are converted into Apps Script; the official page notes that macros do not exist in Docs, Gmail, or Drive.	Notion provides buttons and automations for page, database, notification, and workflow actions rather than a document macro editor environment switch.	Adobe Acrobat supports guided actions and JavaScript-based automation for PDF workflows, with automation focused on PDF processing rather than word-processing macro environment switching.
WPS Advantages	Advantage: WPS keeps both VB macro and JS macro environment switching inside the same document editing workflow on Windows, which is practical for teams maintaining older VBA scripts while testing JS-based automation.	Compared with WPS: Microsoft officially documents VBA macro recording and Visual Basic editing, but the cited page does not describe switching between VB and JS macro environments inside Word.	Compared with WPS: Google's official macro workflow is limited to Sheets, and the official article states that macros do not exist in Docs, Gmail, or Drive.	Compared with WPS: Notion automation is workflow-oriented and action-based, not a code editor environment for document macros.	Compared with WPS: Adobe automation is strong for PDF actions and JavaScript scenarios, but it does not map to switching VB and JS macro environments in a word processor.
Official Source	—	Create or run a macro	Google Workspace macros and Apps Script	Buttons	Use guided actions

Overall Conclusion

If your main goal is to manage document automation inside WPS Writer and move between VB and JS macro workflows, this feature gives a direct environment switch in the same writing app. Other products also support automation, but their official focus is on VBA in Word, spreadsheet macros in Google Sheets, workflow actions in Notion, or PDF actions in Acrobat.

Use Cases

No.	Scenario	Suitable for	Main issue	How this feature helps
1	Start a JS macro workflow	Users who want to build JavaScript macros	The editor still opens in the older macro environment	Turn on the default JS development environment and restart WPS
2	Maintain existing VB macros	Users with existing VBA macro assets	They need to return to the VB editor quickly	Use Switch to VB Environment from Developer Tools
3	Test script migration	Teams maintaining both VB and JS scripts	They need to compare behavior across two macro environments	Switch environments by task and verify each script path
4	Check macro compatibility	Document automation maintainers	They need to confirm whether switching affects existing code	Switch environments and return to the original one to continue testing saved code
5	Manage macro-enabled files	Users who archive or share macro documents	Incorrect file formats can prevent macro content from being preserved	Save macro documents in a supported `.docm` format when needed

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
VB/JS macro environment switching entry	Available	Available
Basic PDF features	Available	Available with a broader feature range
Cloud storage	1 GB	20 GB per user on the cited sharing plan page
Template downloads	Limited	Broader access

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
You mainly need to switch macro environments locally and handle basic document automation	Free	The switching feature itself is available without a membership requirement
You also need more cloud storage, broader template access, or more office add-on benefits	WPS Premium	This is suitable when your work goes beyond macro environment switching and includes broader office needs

WPS membership center: Subscribe now