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
|
Dim woApp As Word.Application
Set woApp = CreateObject("word.Application") 'ouvre Word
Dim DcTemplate As Word.Document 'document template
Dim DcResultPP As Word.Document 'resultat publipostage
woApp.Documents.Open FileName:=sPathDocWord, ConfirmConversions:=False, ReadOnly:= _
False, AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:= _
"", Revert:=False, WritePasswordDocument:="", WritePasswordTemplate:="", _
Format:=wdOpenFormatAuto, XMLTransform:=""
woApp.Visible = True
Set DcTemplate = woApp.Documents(sPathDocWord)
Set DcResultPP = woApp.Documents.Add
DcTemplate.MailMerge.OpenDataSource Name:= _
sPathFileRapportXls, _
ConfirmConversions:=False, ReadOnly:=False, LinkToSource:=True, _
AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:="", _
WritePasswordDocument:="", WritePasswordTemplate:="", Revert:=False, _
Format:=wdOpenFormatAuto, Connection:= _
"Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source="Ssource";Mode=Read;Extended Properties=""HDR=YES;IMEX=1;"";Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet OLEDB:Engine Type=37;Jet" _
, SQLStatement:="SELECT * FROM `POINTS_FINAUX$`", SQLStatement1:="", _
SubType:=wdMergeSubTypeAccess
With DcTemplate.MailMerge
.Destination = wdSendToNewDocument
.SuppressBlankLines = True
With .DataSource
.FirstRecord = wdDefaultFirstRecord
.LastRecord = wdDefaultLastRecord
End With
.Execute Pause:=False
End With |
Partager