MCR: Macro for Compilation of Report-backs (MCR)

This repository contains the code for the Macro for Compilation of Report-backs (MCR), an open-source, generalizable tool designed to provide researchers in health studies with a flexible and scalable method for compiling individual reports.

If you use MCR in your projects, please cite:

• Polka E, Childs E, Friedman A, Tomsho KS, Claus Henn B, Scammell MK, Milando CW. MCR: Open-Source Software to Automate Compilation of Health Study Report-Back. International Journal of Environmental Research and Public Health. 2021; 18(11):6104. https://doi.org/10.3390/ijerph18116104

If you are interested in collaborating on using MCR in your projects, please contact me at cmilando@bu.edu.

This software is covered under a Software Evaluation Licensing Agreement by Boston University.

Using MCR

• Current version only works on PC, not MAC
• Download the most recent version of MCR in Releases
• Read 'How to use MCR' in the Wiki

• MUST DO THIS: In Excel, enable the Microsoft Powerpoint 16.0 Object Library:

  
  ![image](https://drive.google.com/uc?export=view&id=1MhlvMggpeM0wrWFWt1hopUZUlYUOmySo)
  (If the image above does not load, refresh this page)

Contributing code to MCR

If you want to manually update your version or submit pull requests:

• Rubberduck for VBA source control.

In the RubberDuck code explorer, right click the whole mcr file (.xlsm) and select export/import project to your GitHub clone.