Macro to paste chart as enhanced metafile



  • 1. saving some pages of a big file as a separate file, Text organizin
    1. i woulike to know how i can save, say, 3 pages of a 100 page document as separate file.. 2. when preparing larger document, say 100 pages, is there any way i can pre-set the spaces between lines and words without going through all pages (while prepare larger documents, there can come two or 3 spaces between some lines and some to go through the whole document is time consuming)
  • 2. Exporting AutoCorrect Entries into a Text File
    I need to get AutoCorrect entries into some sort of text file. Is there any way to do this? Using various versions of Word: 2000, 2002, 2003.
  • 3. File- Send to:mail recipient(),()??
    Word 2003: Am unable to add usable/clickable mail recipient(for review, and as attachment) to File send to menu. Mine is in the background and cannot be accessed. Have been to Tools-customize-commands-file; and have dragged and dropped Mail Recipient ; reply with Changes and send for review over to the File menu. It was entered but sits in the backgnd and is inaccessible. Same program on another computer (XP Professional) works fine. Have checked mapi32.dll in Windows Sys file, everything OK......need help please.....
  • 4. Display a math formula?
    I am in a statistics class and need to display a formula in Word. How can I get a mathematical formula in Word?
  • 5. File View Order
    When I open folder in Word, I would like files to show with latest date on top- universally. My Word 2003 defaults to earliest date. How to change? Also, in detail view how to change universal default for what shows, e.g. type, size, etc. Thanks. forsyte

Macro to paste chart as enhanced metafile

Postby SmF5bmU » Sat, 19 Dec 2009 03:31:03 GMT

I have a large number of excel charts to paste into Word as enhanced 
metafiles.  I need a macro to do this, but can't figure out how to write it.  
Any help would be appreciated! 

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?


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, 

...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)


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?


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 

     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?


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)

Return to MS WORD


Who is online

Users browsing this forum: No registered users and 57 guest