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

I found a code on the Internet and I've adapted to my own use to automate copy-paste. Works great except that when I paste the Excel chart to my word report, the colors get changed to destination theme. I need to keep source formatting and as the report is final, I can't change the color scheme either.

For some reason Selection.PasteSpecial (wdChart) does not work, it's used as a simple paste. I've got hundreds of reports to paste two dozens of graphs to, I would not want to do if manually!

Please Login or Register  to view this content.

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...