Excel charts from separate sheets into Word using VBA

[barleywine]

Hi,
I too am trying to copy Excel charts into Word, but the charts were created as separate sheets in Excel rather than as objects in one sheet. Can anyone tell me how to do this please - I think I need to loop through the sheets which are charts but ignoring the sheets which are data tables but am not sure what object to reference?

Cheers

Barleywine

:->

 

[RobBroekhuis]

I just posted this in the other thread, but a new thread may be more appropriate, so here goes again:

dim Sh as sheet
for each Sh in activeworkbook.sheets
if typename(Sh)="Chart" then
Sh.activate
activechart.copypicture ....
end if
next Sh
Rob