Problem / Goal
An Italian company needed a tool to automate the task of preparing long reports based on a large number of pictures. The pictures were produced by optical inspection equipment controlling glass containers used in pharmaceutics. The name of each picture contained a sample number and test results, and until then the entire reporting procedure was done manually using MS Word 2003.
The tool was implemented as a VBA macro working for Word 2003 and later. The macro performed a number of calculations based on the file names, created appropriate content in the Word document and inserted pictures and tables with calculated values.
The tedious task of writing reports was fully automated.