Hi everyone, I'm hoping you can help me with my query.

I am currently using a vb front end to open a word document and generate a report which includes a number of charts.

i have generated a document template with standard text and bookmarks, which i reference in my code, indicating where i would like the charts to be placed and i use the following line in my program to do this:

Set oWordShape = docIPTool.Shapes.AddOLEObject(ClassType:="MSGraph.Chart.8", Width:=400, Height:=250, Left:=100, Anchor:=docIPTool.Bookmarks("grphincomeaa").Range)

it all works fine until i look at where the chart has been placed in the document and most times it seems to be nowhere near the bookmark.

for example the bookmark might be in the middle of the page and while the anchor shows up there the chart will be at the top of the page or on the next or previous page as well as obscuring the text

the other thing i would like to do is convert the chart to a picture file in the word document rather than it being an embedded chart so any help with that also would be greatly appreciated

cheers