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
|
Private Sub CommandButton1_Click()
Dim docWord As Word.Document
Dim appWord As Word.Application
Dim NomBase As String
NomBase = Application.GetOpenFilename("Nom fichier,*.xls")
Dim wkbCib As Workbook
Dim wksCib As Worksheet
Dim dernLigCib As Integer
Set wkbCib = ActiveWorkbook
Set wksCib = wkbCib.Worksheets("Base")
Dim nom As String
nom = Application.GetOpenFilename("Nom fichier,*.docx")
Application.ScreenUpdating = False
Set appWord = New Word.Application
appWord.Visible = True
Set docWord = appWord.Documents.Open(nom)
With docWord.mailMerge
.OpenDataSource Name:=NomBase, _
Connection:="Driver={Microsoft Excel Driver (*.xls)};" & _
"DBQ=" & NomBase & "; ReadOnly=True;", _
SQLStatement:="SELECT * FROM [Base$]"
.Destination = wdSendToPrinter
.suppressBlankLines = True
With .DataSource
.firstRecord = wdDefaultFirstRecord
.lastRecord = wdDefaultLastRecord
End With
.Execute Pause:=False
End With
Application.ScreenUpdating = True
docWord.Close False
appWord.Quit
End Sub |
Partager