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

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.

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.

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. WPS Office shows "macros cannot be run because

Steps:

  • Save the file. Warning: This will permanently remove all VBA code.
  • 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. Save the file

    The free “Personal Edition” of WPS Office does not include VBA support. The VBA module is a feature of WPS Professional or WPS 365 (Business) .

    What to do:

    Cost: WPS Professional is typically a one-time purchase (~$80 USD) or an annual subscription for 365.