1

I'm copying a range in excel as an image, and I want to insert it into a word document as replacement for dummy text "Qwerty01". Right now it opens the word document and pastes the image at the top - how can I get it to move the cursor to the dummy text before pasting?

Sub automateword()

Dim sheet1 As Object
Dim wdFind As Object

Set wordapp = CreateObject("word.Application")
wordapp.documents.Open ThisWorkbook.Path & "\Word.docx"


wordapp.Visible = True
Set sheet1 = Sheets("Prog General (1)")
Set wdFind = wordapp.Selection.Find

sheet1.Range("D14:N46").CopyPicture Appearance:=xlScreen, Format:=xlPicture
wdFind.Text = "Qwerty01"
wordapp.Selection.Paste
End Sub
Kara
  • 6,115
  • 16
  • 50
  • 57
zliz
  • 59
  • 1
  • 2
  • 6

0 Answers0