chrisellis250
New Member
- Joined
- Jul 17, 2017
- Messages
- 2
Hello,
I have been using the following code to copy data from a worksheet to the bookmarks in a word document.
Is there a way to amend the above code so that images can be copied from a cell to a bookmark in the word document?
I have a commandbutton which pastes images from the clipboard into a specific cell, so I want the above coding to be able to copy this image into the document also.
Many thanks,
Chris
I have been using the following code to copy data from a worksheet to the bookmarks in a word document.
Code:
Sub test()
Dim objWord As Object
Dim ws As Worksheet
Set ws = ThisWorkbook.Sheets("Sheet1")
Set objWord = CreateObject("Word.Application")
objWord.Visible = True
objWord.Documents.Open "C:\test.docx" ' change as required
With objWord.ActiveDocument
.Bookmarks("Text1").Range.Text = ws.Range("A1").Value
.Bookmarks("Text2").Range.Text = ws.Range("A2").Value
.Bookmarks("Text3").Range.Text = ws.Range("A3").Value
End With
Set objWord = Nothing
End Sub
Is there a way to amend the above code so that images can be copied from a cell to a bookmark in the word document?
I have a commandbutton which pastes images from the clipboard into a specific cell, so I want the above coding to be able to copy this image into the document also.
Many thanks,
Chris