1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38
|
Dim Myrange As Variant
Dim Bookstart As Long
Dim Bookend As Long
Dim Bonus_Word As Word.Document
'......
With Workbooks(Personal_workbook).Sheets(Pers_Information_Sheet)
'Personal_workbook
'Populate Word Fields
'Name (1)
Bonus_Word.Fields(1).Result.Text = .Range("D" & Idx)
'Référence (3)
Bonus_Word.Fields(2).Result.Text = .Range("E" & Idx)
'Objectif (4)
Workbooks(Detailled_workbook).Sheets(Details_Sheet).Range(Bonus_Detail_SheetName_Location) = Workbooks(Detailled_workbook).Sheets(Details_Sheet).name
Workbooks(Detailled_workbook).Sheets(Details_Sheet).Range(Bonus_Range_Detail).Copy
Bonus_Word.Bookmarks("Target").Range.PasteSpecial _
Link:=True, DataType:=wdPasteOLEObject, Placement:=wdInLine
'Montant (5)
Bonus_Word.Fields(4).Result.Text = Round(Range("H" & Idx), 2)
'Période (6)
Bonus_Word.Fields(5).Result.Text = Range("J" & Idx)
'************************
Bonus_Word.PrintOut
' Clear at "Target" bookmark position
'Bonus_Word.Characters(Bonus_Word.Bookmarks("Target").Start + 1).Delete
'Remove Inserted Contents at "Target" bookmark
With Bonus_Word.Bookmarks("Target")
Bookstart = .Start
Bookend = .End
End With
Set Myrange = Bonus_Word.Range(Start:=Bookstart, End:=Bookend)
Myrange.Delete
End If
End With |