VBA auto copy-paste from Excel to Word works but no source formatting!

Originally Posted by AlphaFrog

An alternative method is to save the chart as an image file and then insert that image in the Word doc.

Exporting a Chart to a Word Document

That works, however the image formatting and quality is not suitable for printing of the Word reports...