Once the library is installed, you may need to manually enable the macro tools in the interface: Open WPS Spreadsheets (or Writer). Go to Menu > Options . Select Customize Ribbon . Find Developer in the list of main tabs and check the box.
This error typically occurs when the Visual Basic for Applications (VBA) environment is missing or disabled in your installation
This is the most common solution. If you're using WPS personal edition, you need to download and install the VBA plugin separately. Here are your options:
Open the extracted folder to locate the .msi or .exe setup file (often named vba6.msi ). Double-click the file to launch the installation wizard. Step 3: Follow the Installation Wizard Click on the welcome screen. Accept the terms and conditions. Once the library is installed, you may need
WPS Spreadsheets supports (in some versions) and JavaScript as alternative scripting languages. If you cannot get VBA working:
Fixing the "VBA support library is not installed" error boils down to a simple choice. If your workflow relies heavily on legacy Microsoft Office files with complex pre-written VBA code, or upgrading to WPS Premium is your best bet. However, if you are building new automations from scratch, exploring WPS JS Macros provides a smoother, native experience that requires no extra software installations.
Avoid saving macros in older .xls format, as this can restrict functionality and cause macro buttons to become unresponsive. Find Developer in the list of main tabs and check the box
Run the .exe file (typically named vba6.exe or VBAxWPS.exe ).
Sometimes, you may encounter a more specific error like "vba6.dll not found" even after installing the plugin. This is usually due to an improper installation, where WPS cannot locate the correct VBA library files.
If the macro menu appears disabled or gray after VBA installation: Here are your options: Open the extracted folder
Check File > Options > Trust Center > Macro Settings and ensure macros are not completely disabled.
WPS Office Free version does include built‑in VBA (Visual Basic for Applications) support. When you try to run or open a file containing macros ( .xlsm , .docm , .pptm , or files with VBA code), you’ll see: