Put this macro in Excel (2003) where you have your graphs and try it... I hope it can help you:
Sub Macro1()
Dim wdObj As Object
Dim sh As Worksheet
Dim fileToOpen
Dim myCounter As Long
Set wdObj = CreateObject("word.application")
'wdObj.Visible = True 'to view word application
'ask what is word document with graphs
fileToOpen = Application.GetOpenFilename("Word documents (*.doc), *.doc", , _
"Select word document containing graphs")
If fileToOpen = False Then
MsgBox ("No files selected")
Exit Sub
End If
'open word document
wdObj.Documents.Open fileToOpen
'copy chart from Excel
For Each sh In ThisWorkbook.Sheets
'sh.ChartObjects(1).Copy
sh.Activate
sh.ChartObjects(1).Select
ActiveChart.CopyPicture Appearance:=xlScreen, _
Size:=xlScreen, Format:=xlPicture
myCounter = myCounter + 1
wdObj.activedocument.inlineshapes(myCounter).Select
wdObj.Selection.Paste
DoEvents
Next sh
'close and save word document
wdObj.ActiveWindow.Close True
'close word application
On Error Resume Next
wdObj.Quit
Set wdObj = Nothing
End Sub
Regards,
Antonio
Bookmarks