Wps Office Macros Cannot Be Run Because The Vba Support Library Is Not Installed Hot [exclusive] <RECOMMENDED ✯>

Problem summary

WPS Office shows "macros cannot be run because the VBA support library is not installed" (or similar). That means WPS lacks the Visual Basic for Applications runtime or its VBA integration component, so macros (VBA) in the document cannot execute.

Fix 4: Convert the File to a Non-Macro Format (Workaround)

If you do not actually need the macros to run — you just need to view the data — you can convert the file to a standard format.

Steps:

1. If you have access to Microsoft Office (even a trial version or a friend’s PC), open the problematic .xlsm or .docm file.
2. Go to File → Save As.
3. Choose a non-macro format:
   • For Excel: .xlsx
   • For Word: .docx
4. Save the file. Warning: This will permanently remove all VBA code.
5. Open the new file in WPS Office. The macros will be gone, so the error will not appear.

When to use this: You only need the static data/text, and you do not need automation or custom functions.

Fix 1: Download and Install the Official WPS VBA Plugin (Recommended for Free Users)

Kingsoft provides a separate, free VBA plugin for certain versions of WPS Office. This is the most direct solution. Problem summary WPS Office shows "macros cannot be

Steps:

1. Close WPS Office completely (check your system tray to ensure no WPS processes are running).
2. Go to the official WPS Office website: www.wps.com
3. Search for "VBA Plugin" or navigate to the Download section.
   • Note: The plugin is sometimes listed under "Tools" or "Add-ins".
4. Download the file named something like: wps_vba_patch.exe or wps_vba_module.exe.
5. Run the installer as Administrator.
   • Right-click the downloaded file → Run as administrator.
6. Follow the on-screen instructions. The plugin will install the necessary .dll files into the WPS Office directory.
7. Restart WPS Office and try opening your macro-enabled file again.

Result: The error should disappear, and your macros will run normally. If you have access to Microsoft Office (even

Important: The availability of this free plugin varies by region and WPS version. If you cannot find it on the official site, proceed to Fix 2 or Fix 3.

Why Isn’t the VBA Support Library Installed by Default?

There are three common reasons:

1. WPS Free Version Limitations – The free, ad-supported version of WPS Office often excludes VBA support to reduce file size and encourage upgrades.
2. Custom or Portable Installation – If you installed a portable or stripped-down version of WPS, the VBA components may have been omitted.
3. Region-Specific Builds – Some international builds (e.g., certain Chinese versions) include VBA natively, but English or European versions may require manual installation.