Macro to paste chart as enhanced metafile

Similar Threads:

1.Pasting Excel Graphs (charts/enhanced metafile pictures) into Word

I am looking for a similar solution posted by Donahue, 
8/20/04, 7:07 am.

I have pasted excel charts and enhanced metafile pictures 
in a word document, sent this to a colleague who has Word 
2001 for the Mac, and she is unable to view these files.  
She sees a big (red?) X.

Size/memory is not an issue here.

Any help here?

2.Paste Special: Metafile vs Enhanced Metafile

What's the difference between Picture (Windows Metafile) and Picture 
(Enhanced Metafile) in the Paste Special options? Is there a good rule as to 
when to use one over the other?

At a quick look for pasting Excel sheets, they seem the same, but I'd guess 
that's just because Excel sheets don't have any fancy graphics, gradients, 
etc. But that's just my guess. Perhaps Windows Metafile is fine for basic 
shapes and Enhanced Metafile is better for advanced vector images?

Thanks,
Colin 

3.Macro for Paste Special - Picture (Enhanced Metafile)

Hello!  I am trying to set up a macro (key command alt+ctrl+p) that will 
perform the following command: Paste Special - Picture (Enhanced Metafile).  
I tried recording a macro to do this, and it came up with this:

Sub PasteMetafile()
'
' PasteMetafile Macro
'
'
   Application.Run MacroName:="Normal.Module2.EditPasteSpecial
End Sub

When I try to run it, it takes me to the "Paste Special" screen that pops 
up, but it doesn't select Picture (Enhanced Metafile) for me.  I found this 
code from someone else:

AppWord.Selection.PasteSpecial Placement:=wdInLine, 
DataType:=wdPasteMetafilePicture

...but it gives me Error 424 "Object required."

How can I make it specifically choose Picture (Enhanced Metafile)?

Just FYI, I have another macro set up already that tells Word whenever I use 
Paste Special to paste everything as inline rather than floating.

Thank you!

4.Paste Special , Paste link as Picture (enhanced metafile)

Hallo,

One of my colleague wants to paste excel table  in word.

He select the cell and use paste special in Word , paste link and would like 
to  paste as Picture(Enhanced Metafile).

But Picture(Enhanced Metafile option is missing in word.  He only gets 
Graphic (windows metafile)

We are using Office 2003. He told this option was avalaible in Office XP 2002.

Any idea, how to get this option in Word 2003?


Regards,
Atul

5.Windows metafile versus enhanced metafile

I have two questions regarding the PasteSpecial method:

1.) I would like to paste the contents of the clipboard as a "Picture (Windows
Metafile)" to the active cell of a table in Word using VB. The code below is 
straight out of the VB help examples. It works if the selection is not inside a 
table but if the selection is inside a table it does not work. If I record the 
actions of paste special to a cell the code generated uses PasteAndFormat, but 
this does not allow me to specify "Picture (Windows Metafile)". What is the 
solution?

     Selection.Collapse Direction:=wdCollapseStart
     Selection.Range.PasteSpecial datatype:=wdPasteMetafilePicture

2.) To reduce Word document file size I have always pasted graphics (charts, 
etc.) as "Picture (Windows Metafile)" rather than "Picture (Enhanced Metafile)"
believing that the former is smaller in size than the latter. Is this true?

Thanks
Alex

6. Pasting from xl into word as an enhanced metafile

7. Pasting Excel cells as "Picture (Enhanced Metafile)"

8. Editing a Table Pasted from Excel into Word as a Picture (Enhanced Metafile)