Bonjour, le probleme est de centrer l'element exporté. Merci pour votre aide !

Code : Sélectionner tout - Visualiser dans une fenêtre à part
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
Function ExportTabRest(wsSheet As Worksheet, sChemin As String, rTab As Range, sTitre As String, bDimensionner As Boolean)
 
        Dim lNbTableaux As Long
 
        Set WdApp = Word.Application
        Set wdDoc = GetObject(sChemin)
        WdApp.Visible = True
 
        wsSheet.Select
        rTab.Copy
 
        WdApp.Selection.EndKey Unit:=wdStory, Extend:=wdMove
        WdApp.Selection.TypeParagraph
        WdApp.Selection.Paste
        'WdApp.Selection.ParagraphFormat.Alignment = wdAlignParagraphCenter
        WdApp.Selection.InsertCaption Label:="Tableau", Title:=(" : " & sTitre), Position:=wdCaptionPositionBelow, _
        ExcludeLabel:=0
 
        lNbTableaux = wdDoc.Tables.Count
 
        Application.CutCopyMode = False
 
        If bDimensionner = True Then
        wdDoc.Tables(lNbTableaux).AutoFitBehavior wdAutoFitWindow
        End If
 
 
End Function
 
Function ExportTabAsPictureRest(wsSheet As Worksheet, sChemin As String, rTab As Range, sTitre As String)
 
        Dim lNbTableaux As Long
 
        Set WdApp = Word.Application
        Set wdDoc = GetObject(sChemin)
        WdApp.Visible = True
 
        wsSheet.Select
        rTab.CopyPicture
 
        WdApp.Selection.EndKey Unit:=wdStory, Extend:=wdMove
        WdApp.Selection.TypeParagraph
        WdApp.Selection.PasteSpecial Link:=False, DataType:=3, _
        Placement:=wdInLine, DisplayAsIcon:=False
        WdApp.Selection.TypeParagraph
        WdApp.Selection.InsertCaption Label:="Tableau", Title:=" : " & sTitre, Position:=wdCaptionPositionBelow, _
        ExcludeLabel:=0
        Application.CutCopyMode = False
 
 
End Function
 
Function ExportGraphRest(wsSheet As Worksheet, sChemin As String, sGraphNum As String, sTitre As String)
 
        Set WdApp = Word.Application
        Set wdDoc = GetObject(sChemin)
        WdApp.Visible = True
 
        wsSheet.Select
        wsSheet.ChartObjects("Graphique " & sGraphNum).Activate
        ActiveChart.ChartArea.Select
        ActiveChart.ChartArea.Copy
 
        WdApp.Selection.EndKey Unit:=wdStory, Extend:=wdMove
        WdApp.Selection.TypeParagraph
        WdApp.Selection.Paste
        WdApp.Selection.TypeParagraph
        WdApp.Selection.InsertCaption Label:="Figure", Title:=" - " & sTitre, Position:=wdCaptionPositionBelow, _
        ExcludeLabel:=0
        Application.CutCopyMode = False
 
 
End Function