Project Overview
The client relied heavily on extensive, undocumented Excel VBA macros and a legacy Visual Studio Tools for Office (VSTO) add-in to generate complex financial reports. This legacy architecture was slow, prone to crashing Excel, entirely insecure, and tied analysts to Windows desktop environments. MetaDesign Solutions (MDS) partnered with the client to modernize their entire reporting pipeline, offloading heavy calculations to a secure backend API and building a lightweight, cross-platform Office.js web add-in.
Legacy Macro & VSTO Analysis
We began by conducting a deep dive into the undocumented VBA and VSTO codebase. Our engineering team meticulously reverse-engineered the complex financial formulas and reporting logic, decoupling the calculation rules from the user interface and mapping out a modern, scalable architecture.
Secure Backend API & IP Protection
To eliminate local processing bottlenecks and secure the client's intellectual property, we migrated all heavy financial calculation logic from the local macros to a highly secure Node.js backend API. The proprietary formulas are now safely hidden behind an encrypted server infrastructure, drastically reducing the risk of IP theft.
Have a similar challenge?
Our experts can help you build custom integrations and plugins tailored to your business workflows.
Cross-Platform React & Office.js Web Add-in
We built a modern, lightweight Excel Web Add-in using React and the Office.js SDK. This single codebase enables the add-in to run flawlessly not only on Excel for Windows but also on Excel for Mac and Excel on the Web, completely untethering the financial analysts from their legacy Windows machines.
Office Scripts for Reporting Automation
For specific repetitive, client-side spreadsheet manipulations that didn't require backend computation, we implemented secure Office Scripts (TypeScript). This allowed us to execute highly optimized, macro-like behavior safely within the modern Excel ecosystem.
Key Challenges
Challenge 1
Legacy VBA macros were extremely slow and frequently crashed the local Excel instances during heavy reporting runs.
Challenge 2
The VSTO add-in locked the workforce into using Windows desktop machines, hindering a transition to hybrid work on Macs or the Web.
Challenge 3
Critical intellectual property (financial formulas and logic) was exposed within the VBA code, presenting a massive security risk.
Challenge 4
Total lack of documentation for the monolithic macro codebase made maintenance and scaling nearly impossible.
Results & Outcomes
The comprehensive modernization transformed the client's reporting capabilities. Report generation times were reduced drastically as calculation overhead was moved to the cloud. Analysts now enjoy a smooth, crash-free experience on any operating system—Windows, Mac, or Web. Most importantly, the financial firm secured its most valuable intellectual property, ensuring a scalable, future-proof platform for wealth management reporting.
