I want to automate the process of creating a custom word document from an Excel workbook

Question

I have a custom model built in Excel with 10+ sheets that I regularly need to convert into a word document or a presentation for meetings. Since the word document's formatting remains about the same, I want to automate the process of making these word documents. Can anyone help me with a starting point of how I could make a word template, and then automate the process of converting all future excel models to fit this word template? Thank you in advance.

Answer 1

hi! @Prasham Parikh
though I don't know what your word template is,

with the word template found on the web,

then I created a macro to input the contents of Excel.

please refer.

some automate exsample

the process of creating a word document from an Excel workbook

To run the macro,

Download the whole folder,

Please expand .
folder address
https://1drv.ms/f/s!At950JyIeN6wgewXnjWshBsT3h07rA?e=UFQZNB