I have used the following coe to open a word template and selct a cell in excel that needs to be pasted to a bookmark in word.
The code highlights the whole document but I need it to place the copied cell at the bookmark.
Can somone give me an idea as to the code that will select the bookmark and paste the copied cell.
The last line highlighted shows as runtime error 424, if that helps.
Sub Address()
Dim wdApp As Object
Dim wdDoc As Object
Set wdApp = CreateObject("Word.application")
Set wdDoc = wdApp.Documents.Open _
(FileName:="C:\My Documents\MCR\Clt Ltrs\Let1")
wdApp.Visible = True
Range("A1").Select
Range("B60").Select
Selection.Copy
wdDoc.Select
ActiveDocument.Bookmarks("Address1").Range.Text = "Hello world"
End Sub
Bookmarks