initial.xlsm - Macro-enabled Excel file containing the VBA script; template.docx - MS Word template file VBA script replaces text in; initial data.xlsx - a dictionary of items to be replaced; sample ...

To recreate my results, click This Excel File and then "view raw" to download the stock data, then paste the text from my VBA Script into a module within VBA. Finally click the developer tab and run ...