Apologies in advance. I have posted this somewhere but not as a new query.

I need to find some VBA to export charts out of Excel 2000 into MS Word 2000 as pictures. Once they exist as picture files, I then need to merge them using 'IncludePicture' merge field in a mail merge document.

Is there anyone who could please point me in the right direction?

Thanks in advance,

Sanjo

>I need to find some VBA to export charts out of Excel 2000 into MS Word 2000 as pictures

When export is done, the chart remains chart and not a image.

>Once they exist as picture files,...

Here you have to cope the chart and save them to a file... some thing like this Eg:- Me.ActiveChart.CopyPicture xlScreen, xlBitmap, xlScreen

Or to ease the work...
First the VBA code depends from where it runs from.,,,
1) EXCEL file which contains charts and export to WORD or
2) WORD file from which you want to read the chart object and bring it in.
OR
3) You have VB app that does this EXCEL VBA and WORD VBA on the click of the button and read the excel file and write back to word doc?

Here the code differs and from the both the point of view the work is simple (no complex code) but lot of childish :D lines of code you have to write.

With Regards,
Raghavendra Mudugal