Word Macros - Paste Special (picture)

[ceecld]

Hi there, im looking to setup a little macro that takes whats in the clipboard and does a paste special (picutre). Im using it to bring tables in from excel.

Well i tried using the macro recorder, however it seems to think i am doing a normal paste operation:

Selection.PasteAndFormat (wdPasteDefault)

Basically im just looking for the parameters required for the function PasteSpecial, i think!?

Selection.PasteSpecial (.....)

Thanks for your help

 

[Loomah]

hi
I've just recorded this

Selection.PasteSpecial Link:=False, DataType:=wdPasteMetafilePicture, _
    Placement:=wdFloatOverText, DisplayAsIcon:=False

;-)

If a man says something and there are no women there to hear him, is he still wrong?
The faqs ma'am, just the faqs. Get the best from these forums : faq222-2244

 

[ceecld]

Thanks for that, how do i get it to have a layout 'inline with text' as currently its pasting it 'in front of text'

Thanks again

 

[ceecld]

Fixed it now! i see you had selected it to fload over text.

Thanks
again