The initial situation was characterized by an outdated 32-bit Office environment that received no support from Microsoft anymore.
Numerous productive workbooks and Access databases contained VBA macros, embedded add-ins and database connections whose behavior was not secured under 64 bit. It was particularly critical that individual add-ins were embedded in dozens of workbooks: A non-compatible module would have triggered function failures in up to 30 files.
The testing was exacting, as incompatibilities could not be detected automatically on their own. ActiveX controls, DLL calls or shell commands had to be tested manually and adapted if necessary. At the same time, priorities had to be set: of a total of almost 200 files, the most important 30 were tested intensively, as they were used company-wide in reporting, calculation and document generation. The aim was to achieve a changeover without downtime, with validated applications and clearly documented test routines.
jovoco developed a clearly structured testing and customization process for the migration. The focus was on a clean analysis of the VBA structures, a prioritized test list and targeted adjustments to ensure both technical stability and future viability.
Your decision would be the same as that of renowned companies:
