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: 8
Default Insert Chart into Word

I'm not sure if this should be posted here or in the Word NG, but...

I'm trying to write a macro that will copy a selected chart (in Excel) into
an open Word Document (at the current location of the cursor). Unfotunately,
I'm only familiar with the Excel object model, not the Word object model. I
have the following code (but cant figure out what to put in XXXX). Of
course, I may be going about this completely the wrong way. Thanks for any
help...

Sub PortToWord()

Dim WrdDoc As Word.Document

Set WrdDoc = Word.ActiveDocument
ActiveChart.Copy
WrdDoc.XXXX.PasteSpecial DataType:=wdPasteEnhancedMetafile,
DisplayAsIcon:=False


End Sub

 
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
Can not insert chart in Excel 2007? Chart does not work right? Janis Excel Discussion (Misc queries) 0 June 18th 09 08:31 PM
How to insert a word document onto an Excel Chart rb22 Excel Discussion (Misc queries) 1 June 16th 09 06:04 PM
HOW TO INSERT A * BEFORE AND AFTER EACH WORD Brianna Excel Worksheet Functions 2 November 8th 08 04:49 AM
insert excel chart into word doc and keep landscape format? Laura Excel Discussion (Misc queries) 1 February 15th 08 04:56 PM
=SUM Then insert word. iwgunter Excel Worksheet Functions 3 November 1st 04 10:13 AM


All times are GMT +1. The time now is 07:03 AM.

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

About Us

"It's about Microsoft Excel"