If you are going to have users manually selecting ranges as part of the process, you need to do this from Excel. You could create the code in an Excel add-in and distribute that instead.

However it could be practical to run it from Word, if the ranges were known in advance, but from your description that does not appear to be the case.

I would think the only practical solution for working in Word would be to read the selected worksheet into a Userform list box, then allow the user to pick the records to be transferred to the document. The formatting would then have to be applied in Word.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com