Unable to change properties when I paste chart from excel to word

Hi

I have created word document with help of excel.

On another side I have created chart in Excel.

with help of excel vba I want to copy graphs in excel to paste it to word as picture. till this I'm able to do successful coding.

Now problem starts here: after pasting picture, I need to set properties with pasted picture i.e. height, width, inline or behind text ,etc

Please Login or Register  to view this content.

Please help me. Note I have atleast 20 graphs and need to be pasted as picture/image. Secondly is there is any way that I can set Shapes index number. the error occurs due the shape number not found.
Alternative option is to export chart from excel and then insert to word which becomes complex so I can't use it.


Then I tried with For Next loop...Code runs perfectly, but one problem still I'm Facing.

I add logo of my company on first page. Then from 4th page I start pasting my excel Charts to word application.

While pasting first chart it applies settings to first page first image than it goes to second image and so on thill last.

Please Login or Register  to view this content.

Due to this image positions get change.