The customer uses a VBA macro solution integrated in MS Word, which is used for the interactive configuration of the service description / sampling of prefabricated houses. Word or PDF documents are created, which, among other things, are the basis for planning the production/construction of the house and represent the contractual basis for the end customer. A third-party GUI component is used within the Word macros, which is based on Microsoft ActiveX technology. This component is incompatible with the future MS Office 365 environment and is no longer maintained by the third-party provider, so the above-mentioned application will no longer be usable in the foreseeable future. Microsoft plans to no longer support ActiveX technology in the near future, so a sensible alternative should be found. Furthermore, the future of MS Office macros / VBA from Microsoft is fraught with uncertainty. The alternative should therefore be viewed in a technology-neutral manner.
Supplement
As part of the project, the PTA is developing various general alternative solutions, which include corresponding advantages but also disadvantages. The solution approaches range between a short-term technical alternative through a similar third-party ActiveX control while retaining the existing MS Word macro, migration to an MS Office / Access application, integration of the functionality into an existing ERP system, expansion of the internal CRM tool used to the complete redevelopment of the application on a modern technological basis (e.g. a web application). The solution approaches are discussed with the customer regarding various parameters such as feasibility, costs, future viability and provide a basis for decision-making for the next steps.
Subject description
Since none of the proposed solution alternatives is really convincing in all respects, an evaluation of the technological possibilities is carried out in parallel using a practical example. First, the most cost-effective variant (alternative ActiveX control) is considered. However, this shows that no third-party provider currently supports ActiveX technology, so this alternative is being discarded. In the next step, the suitability of MS Access as a solution approach is tested using a prototype. The MS Access programming model can use a large part of the existing Word VBA code and therefore has a corresponding cost advantage – although it is unclear how future-proof the VBA technology will continue to be. As a third alternative, the customer is evaluating implementation via a web application. Although this solution is significantly higher in terms of costs and effort, from the customer's perspective it offers the best prospects for a scalable, future-proof solution.