Excel 2010 - Copy / paste chart as enhanced metafile to Word - not working as expected

Hi. I can't seem to figure out a better way of handling an issue I'm having with copying charts from Excel to Word. This worked just fine in prior versions of Excel including 2007 but with the migration to 2010 it seems like there are some issues now. Below are the primary lines of code that

Please Login or Register  to view this content.

Is the lines of code that actually paste the image in. If I'm running the macro while Excel is visible, the paste is done properly into the Word sized cell ( using a bookmark ) it is going into. If the code is running in the background ( ie Excel not open ), any sizing I've done in Excel is completely ignored. I'm not sure how to resolve this issue. Anyone know of alternatives? Would moving the chart from a chart sheet to an object on a regular data sheet make any difference? The latter would be difficult to implement due to all the other code ( I'm a novice so not 100% sure ) but if it really is the only way then I'll commit the time to it.



** please note that I'm not a vba developer. I'm trying to fix code due to compatibility issues and have spent quite a lot of time looking through all the code ( this is a much smaller subset ) and reading online / Excel 2010 vba books. I have fixed a bunch of things but I'm stuck now when trying to copy over the image