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 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73
| Sub publipostage()
'
Dim A_Doc_Title As String
Dim A_Doc_Origin As String
Dim A_Doc_Reference As String
Dim A_Doc_Issue As String
Dim A_Doc_Date As String
Dim A_AC_Applicability As String
Dim A_Customer As String
Dim A_ATA_Applicability As String
Dim A_Authoring_Name1 As String
Dim A_Authoring_Function1 As String
Dim A_Approval_Name1 As String
Dim A_Approval_Function1 As String
Dim A_Authorization_Name1 As String
Dim A_Authorization_Function1 As String
'
'Activation du fichier "AD_CVD.xlsm", on se place dans l'onglet "Feuil1"
'
Windows("AD_CVD.xlsm").Activate
Sheets("Feuil1").Activate
'
A_Doc_Title = Range("B2").Value
A_Doc_Origin = Range("C2").Value
A_Doc_Reference = Range("D2").Value
A_Doc_Issue = Range("E2").Value
A_Doc_Date = Range("F2").Value
A_AC_Applicability = Range("G2").Value
A_Customer = Range("H2").Value
A_ATA_Applicability = Range("I2").Value
A_Authoring_Name1 = Range("J2").Value
A_Authoring_Function1 = Range("K2").Value
A_Approval_Name1 = Range("L2").Value
A_Approval_Function1 = Range("M2").Value
A_Authorization_Name1 = Range("N2").Value
A_Authorization_Function1 = Range("O2").Value
'
' Ouverture de Word
'
Set WordApp = CreateObject("Word.application")
WordApp.Visible = True
'
'
' Ouverture du document "AB Template.docm" avec Word
'
Set WordDoc = WordApp.Documents.Add(Template:="C:\Users\DF485624\Desktop\TEST\AB Template.docm", Newtemplate:=False, DocumentType:=0)
'
'
' Modification champ
'
WordApp.ActiveDocument.CustomDocumentProperties("A_Doc_Title") = A_Doc_Title
WordApp.ActiveDocument.CustomDocumentProperties("A_Doc_Origin") = A_Doc_Origin
WordApp.ActiveDocument.CustomDocumentProperties("A_Doc_Reference") = A_Doc_Reference
WordApp.ActiveDocument.CustomDocumentProperties("A_Doc_Issue") = A_Doc_Issue
WordApp.ActiveDocument.CustomDocumentProperties("A_Doc_Date") = A_Doc_Date
WordApp.ActiveDocument.CustomDocumentProperties("A_AC_Applicability") = A_AC_Applicability
WordApp.ActiveDocument.CustomDocumentProperties("A_Customer") = A_Customer
WordApp.ActiveDocument.CustomDocumentProperties("A_ATA_Applicability") = A_ATA_Applicability
WordApp.ActiveDocument.CustomDocumentProperties("A_Authoring_Name1") = A_Authoring_Name1
WordApp.ActiveDocument.CustomDocumentProperties("A_Authoring_Function1") = A_Authoring_Function1
WordApp.ActiveDocument.CustomDocumentProperties("A_Approval_Name1") = A_Approval_Name1
WordApp.ActiveDocument.CustomDocumentProperties("A_Approval_Function1") = A_Approval_Function1
WordApp.ActiveDocument.CustomDocumentProperties("A_Authorization_Name1") = A_Authorization_Name1
WordApp.ActiveDocument.CustomDocumentProperties("A_Authorization_Function1") = A_Authorization_Function1
'
'
' => mise à jour champs dans feuilles
WordApp.Selection.WholeStory
WordApp.Selection.Fields.Update
WordApp.Application.Browser.Previous
'
'
End Sub |
Partager