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
|
Sub Bouton29_QuandClic()
ChDir "\\angfs1\users$\baron\Bureau\Travail Antony\"
MkDir ("\\angfs1\users$\baron\Bureau\Travail Antony\" & Cells(9, 3).Value)
Dim Wchemin As String
Dim wrdApp As Object
Dim wrdDoc As Object
Wchemin = "Y:\TKAF\R04\A422\_Commun-Agence\Roger\Fiches ISO\Suivi chantier mod.doc"
Set wrdApp = CreateObject("Word.Application")
Set wrdDoc = wrdApp.Documents.Open(Wchemin)
wrdApp.Visible = True
wrdApp.Selection.HomeKey Unit:=wdStory
Cells(9, 3).Copy
wrdApp.Selection.Goto What:=wdGoToBookmark, Name:="Texte1"
wrdApp.Selection.Paste
Cells(7, 3).Copy
wrdApp.Selection.Goto What:=wdGoToBookmark, Name:="Texte2"
wrdApp.Selection.Paste
With wrdDoc
.Saved = True
chemin = ("\\angfs1\users$\baron\Bureau\Travail Antony")
nom_enr = "Suivi de chantier mod.doc"
wrdApp.ActiveDocument.SaveAs (nom_enr)
End With
wrdApp.Quit
Dim MaVariable As String
MaVariable = "\\angfs1\users$\baron\Bureau\Travail Antony\" & Cells(9, 3).Value
MkDir (MaVariable)
wrdApp.ChangeFileOpenDirectory MaVariable
End Sub |