Before installing, ensure that all WPS Office applications (WPS Writer, Spreadsheets, and Presentation) are completely closed. Failure to do so may lead to installation errors or incomplete component integration. 3. Run the Installer Double-click the VBAxWPS.exe file. Follow the on-screen prompts to complete the installation.
You need to find the archive containing the VBA professional support library specifically packaged for WPS Office. These are typically named vba6chs.msi , wps_vba.msi , or packaged inside a zip file called WPS VBA Setup .
How to Fix "WPS Office Macros Cannot Be Run Because the VBA Support Library Is Not Installed" Before installing, ensure that all WPS Office applications
This error happens because the standard free version of WPS Office excludes the Visual Basic for Applications (VBA) engine to keep file sizes small and save on Microsoft licensing fees.
WPS Office officially provides a separate installer for the VBA support library. Run the Installer Double-click the VBAxWPS
The Professional, Business, and 365 editions include native VBA support. Upgrading removes the error and gives full macro compatibility with Microsoft Office files.
: The software will automatically download and unlock the integrated VBA environment. Method 3: Switch to Built-in JS Macros (Modern Alternative) These are typically named vba6chs
For the changes to take effect, close all open instances of WPS Writer, WPS Spreadsheets, and WPS Presentation. Relaunch your macro-enabled document. The error should now be resolved, and your macros will run seamlessly. Method 2: Upgrade to WPS Office Business or Professional
Update WPS Office
After downloading the installer: