Support Library Is Not Installed Hot Work: Wps Office Macros Cannot Be Run Because The Vba

Fix: "WPS Office Macros Cannot Be Run Because the VBA Support Library Is Not Installed"

If you are a WPS Office user trying to run an Excel or Word document containing macros (VBA code), you may have encountered the frustrating popup error:

"WPS Office macros cannot be run because the VBA support library is not installed."

This message typically appears when opening a .xlsm, .docm, or any macro-enabled file, or when clicking a button that triggers a script. For many users, this error is a dead end—but it doesn’t have to be. Below, we explain exactly why this happens and how to fix it permanently. Fix: "WPS Office Macros Cannot Be Run Because

Alternatives if you can’t enable VBA in WPS

• Use Microsoft Office (Word/Excel) which includes built-in VBA runtime.
• Use LibreOffice with Basic macros (may need macro conversion and different API).
• Extract macro code and run/convert in another environment (Excel for Windows recommended).

Method 1: Install the WPS VBA Module (Official & Easiest)

WPS provides a standalone VBA for WPS package. This is the most reliable fix.

Steps:

1. Close all WPS applications (Writer, Spreadsheets, etc.).
2. Download the WPS VBA Module from the official WPS website or a trusted mirror.
   • Tip: Search for “WPS VBA plugin” or “wps_vba_module.exe”.
3. Run the installer as Administrator (right-click → Run as administrator).
4. Follow the on-screen prompts. The installation takes less than 10 seconds.
5. Re-open WPS Spreadsheets or Writer and try running your macro again.

Result: The error disappears, and macros execute normally.

Note: This module does not require a full reinstall of WPS. It simply adds the missing .dll files and registry entries. "WPS Office macros cannot be run because the

3.3. Solution C: Upgrading to WPS Office Pro/Premium

WPS Office Premium (the paid subscription tier) guarantees full VBA compatibility. If the user relies heavily on complex macros (e.g., UserForms, complex API calls), the free version may be insufficient. Upgrading resolves the issue by unlocking the full, licensed VBA engine.