LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 161
Default XL Charts to Word

Hi,

I am looking to build a macro that will do the following from a single
button click in XL 2003:

1) Open a predefined Word document that I am using as a template;
2) Copy a selected chart to a specified cell within a table in the document;
2) Repeat for several charts to several different cells in Word.

The Word document is actually an A3 page containing a single 3x3 table. I
want to paste (as pictures) 5 different charts to 5 of these cells. The
charts are already generated within the source workbook on different sheets.

I can copy a given chart to a single cell (chosen by where the cursor is) in
an already open document (thanks Jon Peltier), but how do I:

1) Open the Word document from XL (the name and network path are known and
will always be the same;
2) Move the cursor between cells in Word so that I can paste the next chart
in;
3) Move between XL and Word files within a macro - I can do this between
different XL workbooks using Windows(nnn).Activate, is there something
similar between applications?

If someone can solve these for me, I'm reasonably happy that I can sort the
rest of it out.

TIA Dave
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
export Pivot Charts to MS Word? srpd Excel Discussion (Misc queries) 2 January 28th 10 10:56 PM
Copy Charts from Excel to Word kazoo Excel Discussion (Misc queries) 3 August 28th 08 06:28 PM
Excel Charts in Word Marc Charts and Charting in Excel 2 October 17th 07 11:40 PM
copying charts into MS Word kippers Charts and Charting in Excel 1 March 16th 07 02:20 PM
Charts to Word Mike Waldron[_2_] Excel Programming 0 October 22nd 03 02:05 PM


All times are GMT +1. The time now is 12:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"