Here is a breakdown of why this happens and how to resolve it.
He deconstructed his VBA modules one by one. The date parser became a regex in JavaScript. The currency converter became a REST API call using XMLHttpRequest within the WPS JS engine (which, miraculously, worked). The complex pivot-table generator—his pride and joy—he rewrote as a pure array manipulation script.
The error "WPS VBA support library not installed" serves as a reminder that file compatibility does not always equal environment compatibility. While WPS Office excels at mimicking the interface and functionality of Microsoft Office for standard tasks, deep-level automation remains a boundary.