The "VBA support library is not installed" message is common, but easily fixed by installing the dedicated VBAxWPS.exe file. By following the steps above, you can restore full macro functionality to WPS Office, enabling you to automate your tasks and work efficiently in 2026.
Try reinstalling WPS Office completely, then install the VBA plugin immediately after before opening any file. Also, ensure your Windows system has the latest Visual C++ Redistributables installed.
The most common workaround used by the community on forums like Reddit's Excel Community involves manually installing the compatible runtime library. The "VBA support library is not installed" message
In some regions or older versions, VBA support was historically a Premium/Professional
For most users, the solution is a straightforward download. WPS offers a specialized plugin specifically designed to bridge this gap. Also, ensure your Windows system has the latest
Note: If this does not work, it is possible your specific version of the free software is restricted from using this plugin. Method 2: Upgrade to WPS Office Professional/Business
If you are trying to automate tasks in WPS Office and suddenly get hit with the error you are not alone. This is one of the most common roadblocks users face when switching from Microsoft Office to WPS Office. WPS offers a specialized plugin specifically designed to
Upgrading ensures you receive official stability updates, security patches, and seamless compatibility with complex Microsoft Excel macros. Method 3: Switch to WPS Office Built-in JS Macros
WPS Office is not a Microsoft product. It is developed by Kingsoft. While WPS Office is largely compatible with Microsoft Office file formats ( .docx , .xlsx , .pptx ), including VBA support is a .
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