Replicating Chart Apperance with Macro

[Bryan]

Hi.

I've written a macro to help me at work. Basically it mass
produces charts and pastes them into Word. The problem I'm
having is that I can't exactly replicate the manually
created chart apperance - mainly due to the resizing that
is need to insert the document into word (legend and chart
area size).

If you have any tips or advice it would be most
appreciated.

Thanks for your help.
Bryan

 

[Jon Peltier]

Bryan -

You should record macros for all the pieces of your procedure. Somewhere
you must resize the chart manually: see what the syntax and sizes are in
the recorded code. Record what you must do in Word as well, and you can
incorporate these into the Excel macro with appropriate referencing.

I have a few hints for working with other apps on this page:

http://peltiertech.com/Excel/XL_PPT.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______