Integrity Sampling Australia · Workplace Health & Safety / Drug & Alcohol Testing
From VBA Macros to a Resilient Windows Platform
Overview
Integrity Sampling Australia runs drug and alcohol testing programs for workplaces across Australia — from head offices to remote construction and mining sites. Their decade-old dispatch system, built on a series of VBA Word macros, was experiencing data loss and could no longer keep pace with the business. SoftLogic stabilised the existing system, designed an offline-resilient Windows application platform for technicians and supervisors, optimised the workflows end-to-end, migrated the legacy data, and took the new system live.
The Challenge
ISA's job dispatch and result reporting system had been running on interlocking VBA Word macros for over ten years. The system was experiencing active data loss and becoming increasingly fragile. Remote sites — construction zones, mines, and regional locations — meant any replacement architecture had to function without a reliable internet connection. An online-only solution wasn't viable. ISA needed a complete replacement that could be trusted in the field, without disrupting ongoing testing operations during the transition.
What We Did
- 1
Immediate stabilisation of the existing VBA system using OneDrive to halt the active data loss and keep operations running while the new platform was architected.
- 2
Designed an offline-first Windows application architecture for field technicians and supervisors — ensuring full functionality in remote locations with intermittent or no internet connectivity, with reliable sync when connections were restored.
- 3
Worked through ISA's end-to-end dispatch and reporting workflows with the team, identifying inefficiencies and optimising the process before encoding it into the new system — not just replacing like-for-like.
- 4
Built the replacement Windows applications for technicians and supervisors, covering job scheduling, technician dispatch, test result collection, client reporting, and accounts — all integrated and replacing the fragile macro chain.
- 5
Migrated all legacy data from the old VBA-based system into the new platform, ensuring continuity of historical records with zero data loss on cutover.
- 6
Managed a structured go-live with acceptance testing, training, and a supervised transition — moving from the old system to the new one with the team confident in what they were taking on.
“Over the years we had tried a number of solutions for coordinating jobs for our technicians. Our technology had become 10 years old and consisted of a series of VBA word macros that had to work together to dispatch jobs to the right technician and to collect all the information on the test results and report on them for each client. George and team stabilised the system using OneDrive to stop the data loss that we were experiencing and architected a new system of Windows Applications for Technicians and Supervisors. The architecture that was chosen had to be resilient and support operations when internet was not available. Some of the remote locations we operate in presented challenges that precluded an online only solution. George's team not only implemented a replacement system but also thought through the workflows and optimised them. They migrated the old data and presented the team a new system that operated far more efficiently and reliably. Once tested and accepted we went live and have been reaping the benefits. I highly recommend SoftLogic for their expertise and careful process.”
Software Rescue
or Replace
Methodology
A Structured Decision Framework
for Business Leaders & CTOs
Before you rewrite, make the right call.
Most organisations rewrite software they should rescue — wasting years and millions discovering complexity already embedded in the system they abandoned. This free methodology gives you a structured framework to make the rescue-or-replace decision with confidence, before committing to either path.
- The 5-dimension framework for evaluating rescue viability vs. full redevelopment
- The 3-phase rescue process — Resuscitation, Rejuvenation, and Renovation — explained in full
- The 7-step triage methodology for taking ownership of an unknown or orphaned codebase
- How to reduce redevelopment risk with incremental modernisation
- The financial case: why rescue-first consistently delivers better ROI than a big-bang rewrite
Got a problem to solve?
Whether you're starting from scratch, scaling up, or dealing with a system under stress — let's talk about what we can build together. We can start by ensuring your systems continue to operate while a strategy is developed to make the most of your investment.