Hi All

I am trying to write a Word macro that will copy data from Excel and paste
it into a word document as a picture.  Generally, if I don't know how to do
something in code I just record a similar macro and modify the code as
appropriate.  However, this approach seems to have failed in this instance.  
On record a macro to do this, Word creates the line:

Selection.PasteAndFormat (wdPasteDefault)

In recording the macro it works fine.  However, when I insert this into my
code and run it, the Excel data is copied into a Word table.  On the
offchance I have tried using the wdChartPicture constanct but that didn't
work (presumably because its not a chart!) and also used PasteSpecial instead
of PasteAndFormat but all to no avail.  Does anybody know how to do this?

Thanks

Andy