“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 supports generating the following:
- Headings
- Paragraphs
- Normal and inline Equations
- Tables (only row input)
- Page breaks
- Styles
- Right to left languages (e.g. Arabic)
Download link:
https://bit.ly/3vSjaMq
Note:
You must allow the Microsoft Word Object library from the VBA editor in order to use this tool:
Navigate to Tools → References → Microsoft Word xxxx Type Library, where xxxx is the version of Word you’re using.
