If you have recently tried to run a macro-enabled spreadsheet or document in WPS Office (Writer, Spreadsheets, or Presentation) and were greeted with the frustrating error message:
feature. If you are using a strictly limited free version, you may need to upgrade to a version that explicitly includes VBA support, though many current "Free" versions allow the manual installation of the VBA 7.1 add-in. Summary of Key Steps Check Ribbon Ensure the "Developer" tab is visible. Download VBA 7.1 Provides the missing library files needed to run code. Macros require this specific file format to execute. Security Settings
When VBA was working before but suddenly fails:
Summary WPS Office is a lightweight, affordable alternative to Microsoft Office with strong compatibility for common document formats. However, users relying on Excel-style VBA macros can run into a critical roadblock: macros sometimes fail with the error "VBA support library is not installed," preventing macro execution entirely. That limitation significantly reduces WPS's usefulness for power users and organizations that depend on automation. If you have recently tried to run a
Follow the on-screen setup wizard instructions. Click until the installation finishes. Step 3: Restart and Verify WPS Office Open WPS Spreadsheets or WPS Writer . Look at the top menu bar for the Developer tab.
For example, Application.FileDialog is completely unavailable in WPS. You'll need to use WpsApp.Dialogs(wdDialogFileOpen) instead, though this works only within the WPS text component.
: Built specifically for enterprise environments, this version comes with fully licensed VBA support out of the box. Download VBA 7
Macros only run in specific file formats. If you are using a standard file, macros will not work. Ensure the file type is set to Excel Macro-Enabled Workbook (.xlsm) 4. Professional vs. Free Version
💡 If macros still won't run, check if a local installation of Microsoft Office is interfering with WPS's path to the VBA libraries. How to Add & Enable Macros on WPS Office !! Latest 2025
For those using WPS Office on Linux (e.g., Ubuntu), standard VBA support is often missing. Users typically need to seek third-party community packages or use the Enterprise version to enable full macro functionality. Ask Ubuntu download link to the official VBA 7.1 support package or help troubleshooting a specific macro error code? However, users relying on Excel-style VBA macros can
This is normal for the free edition.
: VBA and macro features are generally reserved for the Professional/Business versions or specific Premium tiers.
Once enabled, you'll find VBA Editor, Macro, and other development tools readily accessible from the main ribbon.
By following these steps, you should be able to resolve the VBA support library issue and run macros in WPS Office. If you continue to encounter issues, you may want to consult the WPS Office documentation or contact their support team for further assistance.
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.