PDA

View Full Version : Solved: Paste Special (Picture Windows MetaFile)



icelizard
04-19-2006, 05:45 AM
does anyone know the code for VBA Word macro to paste special using "Picture (Windows Meta File)"

Normally to find out i would create a new macro and act it out with the mouse, but after lookling at code it only does a basic paste special. Any ideas greatly appreciated.!

Killian
04-19-2006, 07:09 AM
Hi and welcome to VBAX :hi:

You can specify the data type when you use the PasteSpecial methodSelection.Range.PasteSpecial DataType:=wdPasteMetafilePictureThis will paste whatever's on the clipboard into the the insertion point as an metafile. (If the clipboard data isn't compatible, you'll get an error)
You can get more info on usage by selecting the method/property in the VBE and pressing F1

icelizard
04-19-2006, 08:02 AM
cheers that worked!