1 2 Previous Next 15 Replies Latest reply on Aug 29, 2012 11:12 AM by Michael Cristiani

    Powerpoint Add-In to paste as EMF (attached)

    Alex Kerin

      I often copy images out of Tableau into Powerpoint. To get a decent image quality without fuzziness you need to paste it as an enhanced metafile. In Powerpoint 2010 (and maybe 2007), MS removed the option to have "Paste as EMF" as a separate button - you have to go through paste special.


      This add-in adds a button to the home tab that allows one click EMF pasting.


      Put this in your add in directory - mine was: C:\Users\MY USER NAME\AppData\Roaming\Microsoft\AddIns


      and then add it under file, options, add-ins, powerpoint add-ins, go, add new, and select it

      I provide absolutely no guarantees about this. It is however a very simple macro:


      Sub insertEMF()

      On Error GoTo errHandler

      ActiveWindow.Selection.SlideRange(1).Shapes _

      .PasteSpecial ppPasteEnhancedMetafile

      Exit Sub


      If Err.Number = -2147188160 Then

      MsgBox "Nothing in clipboard that can be pasted as an EMF", vbOKOnly, "No Image"


      MsgBox Err.Number & ": " & Err.Description, vbOKOnly, "Error"

      End If

      End Sub


      And uses the simplest of XML to add the button (http://www.pptalchemy.co.uk/custom_UI.html)

        1 2 Previous Next