Jump to content

Moving charts fom excel to word.

- - - - -
Started by Guest_priorityone_* , Jan 06 2007 03:22 AM

This topic has been archived. This means that you cannot reply to this topic.
4 replies to this topic

#1
Guest_priorityone_*
Posted 06 January 2007 - 03:22 AM

Guest_priorityone_*
  • Guests
I am trying to move charts that I made in excel to a word document via a macro. Does anyone know what code would allow me to do this. So far I have the code to open the word document but can't seem to get the rest.

#2
xXHalfSliceXx
Posted 06 January 2007 - 02:03 PM

xXHalfSliceXx

    Speaks fluent binary

  • Moderators
  • 1,694 posts
in the 'ws' loop, add this: (I'll let you decide where, it'll need another paste afterwards)

ws.ChartObjects.Copy

After all is done, Word's 'View' needs to be changed to 'Print Layout' to see the chart(s).

Posted Image
Posted Image

#3
Guest_priorityone_*
Posted 06 January 2007 - 02:24 PM

Guest_priorityone_*
  • Guests
I will use this, am sure this is what I was looking for:)

#4
xXHalfSliceXx
Posted 06 January 2007 - 02:39 PM

xXHalfSliceXx

    Speaks fluent binary

  • Moderators
  • 1,694 posts
well you posted on another forum. And i found the reply to it.

Posted Image
Posted Image

#5
xtraze
Posted 07 January 2007 - 03:19 AM

xtraze

    Programming God

  • Members
  • PipPipPipPipPipPipPip
  • 910 posts
I just copy/paste lol,
Why use a macro to copy a chart ??
Maybe I understood wrong, But.

Quote

I am trying to move charts that I made in excel to a word document via a macro

Back to Computer Software/OS




  1. CODECALL Programming Forum
  2. → General Computing
  3. → Computer Software/OS
IPB skins by Skinbox