Macros to export graphs with specific formating

[chintan_1985]

I have to copy and paste almost 300 chart every week (on Thursday).


I don't know the VBA Macro and aware that VBA could help me out in this work.


I want to export all the graphs with particulart formating as follow:


Graph Size: L: 3.6"

Font size: 6

Graph Header Fornt Size: 8

Graph Header Fornt Alli.: Left

Graph Alli.: Centre


In word File it looks like ...

Indian Bank Bond

< Collumn Chart>


<Petroplot Chart>


I want to develop Macro for the same...


Anyone can develop that or suggest some book for VBA Macro so that I can learn and develop. Thanks.

 

[Luke M]

Doing a quick Google search for "export excel graphs into word macro" returns several promising results. I'd suggest giving them a look and adapting one of them to match your specific needs.