Hi everyone,
I'm trying to replace some text in a Word-file with a copy of a range from Excel. I want to paste the range as an image. At this point, it does paste the range as an image, but I can't seem to fix it so it would replace the specific text. My code is as following:
So to elaborate: the Range I13:M160 of the Sheet "Offerte" has to replace the text "<<Tabel>>" in the Word-document. Everything works, except for the replacement of the text.With msWord.Content.Find Sheets("Offerte").Range("I13:M160").Select Selection.CopyPicture Appearance:=xlScreen, Format:=xlPicture .Text = ("<<TABEL>>") .Replacement.Text = msWord.Selection.Paste msWord.Selection.TypeParagraph End With
Any ideas? Many thanks in advance!