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
| Sub RetourVersWord()
Dim WordApp As Word.Application
Dim WordDoc As Word.Document
Set WordApp = CreateObject("word.application") 'ouvre une session Word
Set WordDoc = WordApp.Documents.Open("C:\Users\asus\Desktop\testMacro\test2.doc") 'ouvre le document Word
WordApp.Visible = False 'Word est masqué pendant l'opération
WordDoc.Bookmarks("chapitre").Range.Text = Cells(2, 1)
WordDoc.Bookmarks("sousChapitre").Range.Text = Cells(2, 1)
WordDoc.Bookmarks("nom").Range.Text = Cells(3, 1)
WordDoc.Bookmarks("marque").Range.Text = Cells(4, 1)
WordDoc.Bookmarks("code").Range.Text = Cells(5, 1)
WordDoc.Bookmarks("reference").Range.Text = Cells(6, 1)
WordDoc.Bookmarks("prix").Range.Text = Cells(7, 1)
WordDoc.Bookmarks("descriptif").Range.Text = Cells(8, 1)
WordDoc.Bookmarks("composition").Range.Text = Cells(9, 1)
WordDoc.Bookmarks("tailles").Range.Text = Cells(10, 1)
WordDoc.Bookmarks("coloris").Range.Text = Cells(11, 1)
WordDoc.Bookmarks("poids").Range.Text = Cells(12, 1)
WordDoc.Bookmarks("homme").Range.Text = Cells(13, 1)
WordDoc.Bookmarks("femme").Range.Text = Cells(14, 1)
WordDoc.Bookmarks("mixte").Range.Text = Cells(15, 1)
WordDoc.Bookmarks("enfant").Range.Text = Cells(16, 1)
WordApp.Visible = True 'affiche le document Word
End Sub |
Partager