Transfering Excel Graphs to Word

I have been trying to figure out how to transfer/export whatever graphs that I created in excel into a word document using a macro. So I guess my question is ....is there a macro code to move charts from excel into a word document? help would be deeply appreciated

Hi,

Turn on your macro recorder ...
and proceed with a test, you will get the
CopyPicture instruction ...

HTH
Carim

Unfortunately isn't working maybe I am missing a step. guess there is no way for excel to automatically open a fresh word document and transfer the charts over there huh?

Hi,

Excel can open Word ...

Please Login or Register  to view this content.

HTH
Carim

Looks great, however for some reason it is not recognizing WDApp.Documents.Open Filename:="C:\Test.doc" any ideas?

Sub OpenWord()
Dim WDApp As Object
Dim WordDoc As Object
Set WDApp = CreateObject("Word.Application")
WDApp.Documents.Open Filename:="C:\Test.doc"
WDApp.WindowState = wdWindowStateMinimize
End Sub

Basically my problem is it opens word fine which is awesome but how to I get it to open a new document as well when it opens. Bascially I'm trying to get a smooth running macro that does all the work i need it to do in excel which it is doing great but now I need it to keep running opening up word and transfering charts to a word document. So now that word is open it's great how do I proceed from here?

Hi,

Below is code for excel to open Word and add a new document ...

Please Login or Register  to view this content.

HTH
Carim

You are awesome thank you so much.


One more question if you have time.....Is it possible now that I opened the word document to run word features via that same excel macro?

Yes ...

Excel can launch all Word macros you have ...

HTH
Carim