Setup

MCR sequentially inserts participants' numerical, text, and graphical results into a report-back template and saves an individual report for each participant. MCR is composed of a macro-enabled Microsoft Excel workbook that contains scripts written in Microsoft Visual Basic for Applications (VBA).

There are typically three components involved in using MCR to compile individualized reports. The first component is the template, which contains the layout and general text for each page of the report. The second component is producing individualized participant results, which can include numerical, text, and/or graphical data. The third component is producing a “Master” Excel workbook, which acts as the container for all participant results. Once these three components are complete, MCR is ready to be used.

For MCR to work, you need to enable the following: Developer | VB | Tools | References | Microsoft Powerpoint 16.0 Object Library (If the image above does not load, refresh this page)