Sub CopierVersWord()
Dim wApp As Object
On Error Resume Next
Set wApp = GetObject(, "Word.Application") 'si Word est déjà ouvert
On Error GoTo 0
If wApp Is Nothing Then Set wApp = CreateObject("Word.Application")
wApp.Visible = True
With wApp.Documents.Add 'nouveau document
.Range.Text = "Bonjour le forum," & vbLf & vbLf 'c'est plus poli
[A5:B7].Copy
.Paragraphs(3).Range.Paste
End With
Application.CutCopyMode = 0
End Sub
Sub CopierVersWord()
Dim wApp As Object
On Error Resume Next
Set wApp = GetObject(, "Word.Application") 'si Word est déjà ouvert
On Error GoTo 0
If wApp Is Nothing Then Set wApp = CreateObject("Word.Application")
wApp.Visible = True
With wApp.Documents.Add(ThisWorkbook.Path & "\Facture.docx")
.Bookmarks("Signet1").Range.Text = Date
[A5:B7].Copy
.Bookmarks("Signet2").Range.Paste
End With
Application.CutCopyMode = 0
End Sub
Sub CopierVersWord()
Dim wApp As Object, i As Byte
On Error Resume Next
Set wApp = GetObject(, "Word.Application") 'si Word est déjà ouvert
On Error GoTo 0
If wApp Is Nothing Then Set wApp = CreateObject("Word.Application")
wApp.Visible = True
With wApp.Documents.Add(ThisWorkbook.Path & "\Facture.docx")
.Bookmarks("Signet1").Range.Text = Date
[A5:B7].Copy
.Bookmarks("Signet2").Range.Paste
With .Bookmarks("Signet2").Range.Find
For i = 1 To 12
.Replacement.ClearFormatting
.Text = Format("1/" & i, "mmmm")
.Replacement.Text = Application.Proper(Format("1/" & i, "mmmm"))
.Execute Replace:=2 '2 => wdReplaceAll
Next
End With
End With
Application.CutCopyMode = 0
End Sub
C'est vraiment un détail, je vous laisse découvrir 2 solutions dans les fichiers (4) et (4 bis) zippés joints.Comment peut-on aligner les deux points ( : ) devant DT, Do et Mois ?
Dim wd As Object, i As Byte
On Error Resume Next
Set wd = GetObject(, "Word.Application") 'si Word est déjà ouvert
On Error GoTo 0
If wd Is Nothing Then Set wd = CreateObject("Word.Application")
wd.Visible = True
Dc = wd.Documents.Add(ThisWorkbook.Path & "\Rapport.docx")
'Set Plg = Dc.Range
With Dc
' Titre1 premier titre en haut de la page, centré verticalement, gras, 14pt et souligné
' Texte = "Rapport mensuel d'activités"
With .Bookmarks("Titre1").Range
.Text = Texte
With Font
.Size = 14
.Bold = True
.Underline = wdUnderlineSingle
End With
.ParagraphFormat.Alignment = wdAlignParagraphCenter
End With
Sheets("1").[T1:U3].Copy
.Bookmarks("Titre2").Range.Paste
With .Bookmarks("Titre2").Range.Find
For i = 1 To 12
.Replacement.ClearFormatting
.Text = Format("1/" & i, "mmmm")
.Replacement.Text = Application.Proper(Format("1/" & i, "mmmm"))
.Execute Replace:=2 '2 => wdReplaceAll
Next
End With
End With
Application.CutCopyMode = 0
Instruction incorrecte à l'extérieur d'une procédure
Dc = wd.Documents.Add(ThisWorkbook.Path & "\Rapport.docx")
Je vous ai offert une "cerise sur le gâteau" c'est suffisant.
Je vous ai offert une "cerise sur le gâteau" c'est suffisant.