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
|
Sub AutoOpen()
'
' AutoOpen Macro
'
Dim o As Object
Dim strNomMod As String
Dim strNomModsExt As String
Dim strPathDef As String
Set o = ActiveDocument
strNomMod = o.Name
strNomModsExt = Left(strNomMod, InStr(strNomMod, ".") - 1)
strPathDef = ActiveDocument.Path
fil$ = strPathDef + "\" + strNomMod
ActiveDocument.MailMerge.OpenDataSource Name:= _
strPathDef + "\" + strNomModsExt + ".csv", ConfirmConversions:=False, ReadOnly:=False _
, LinkToSource:=True, AddToRecentFiles:=False, PasswordDocument:="", _
PasswordTemplate:="", WritePasswordDocument:="", WritePasswordTemplate:= _
"", Revert:=False, Format:=wdOpenFormatAuto
With ActiveDocument.MailMerge
.Destination = wdSendToNewDocument
.MailAsAttachment = False
.MailAddressFieldName = ""
.MailSubject = ""
.SuppressBlankLines = True
With .DataSource
.FirstRecord = wdDefaultFirstRecord
.LastRecord = wdDefaultLastRecord
End With
.Execute Pause:=False
End With
'MsgBox (strPathDef + "\f_" + strNomModsExt + ".doc") --> ligne vérification chemin+fichier
ActiveDocument.SaveAs (strPathDef + "\f_" + strNomModsExt + ".doc")
o.Close (wdDoNotSaveChanges)
End Sub |
Partager