“Excel to Word Report Generator” is a small tool that generates properly formatted Word files based on cell input in Excel. This can be very handy when used as a replacement to “Word fields”. Furthermore, it can be used to add report generation functionality to Excel sheets in general. The code is written in Visual Basic for Applications (VBA) and can be easily imported into any Excel file. The usage of the tool is explained within it.

Current version: 1.0_beta

Supported Features

  • Headings
  • Paragraphs
  • Normal and inline equations
  • Tables (row input only)
  • Page breaks
  • Styles
  • Right-to-left languages (e.g. Arabic)

Excel Report Generator on the left and the generated Word file on the right Excel Report Generator (left) and the generated Word document (right)

Download

Download link: https://bit.ly/3vSjaMq

Setup

You must enable the Microsoft Word Object library from the VBA editor before using this tool:

  1. Open the VBA editor in Excel (Alt + F11)
  2. Navigate to Tools → References
  3. Enable Microsoft Word xxxx Type Library (where xxxx is the version of Word you’re using)
  4. Click OK and you’re ready to go