The error message "WPS Office macros cannot be run because the VBA support library is not installed" occurs because WPS Office, unlike Microsoft Office, does not always include the Visual Basic for Applications (VBA) environment by default. This functionality is typically reserved for the WPS Office Professional/Business editions or requires a separate manual installation of the VBA support package. Common Causes
Transition to JS Macros: Modern versions of WPS Office are pushing toward JavaScript (JS) Macros. Unlike VBA, JS is cross-platform and natively supported by WPS. While this requires rewriting existing code, it is the future-proof method for automation within the suite. Conclusion The error message " WPS Office macros cannot
Standard VBA: Most basic automation and standard commands will work. Control Panel → Programs → WPS Office →
Alternative Solution: Enable VBA Support in WPS Office Alternative Solution: Enable VBA Support in WPS Office
The Error Message: "WPS Office macros cannot be run because the VBA support library is not installed"
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.