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
| Private Sub EnregistrerDocumentPiquage_Page1_Click()
Dim WordApp As Word.Application
Dim WordDoc As Word.Document
Dim fileSaveName As String
Dim CheminModelWord As String
Dim ModelWord As String
Dim ErreurValeur As Boolean
Dim NomFichierNdc As String
Dim Cible As Word.Range
Dim Mouchard As Boolean
Dim CodeImage As String
NomFichierNdc = "FichePiquage_" & Me.Fiche1Document.Value & "_46_" & Me.Fiche3Document.Value
ErreurValeur = False
CheminModelWord = "C:\Program Files\Article\"
ModelWord = "ListeSuiviePiquage.doc"
Set WordApp = CreateObject("Word.Application")
WordApp.Visible = False
Set WordDoc = WordApp.Documents.Open(CheminModelWord & ModelWord, ReadOnly:=False)
DoEvents
'Traitement et ecriture
fileSaveName = Application.GetSaveAsFilename(NomFichierNdc, fileFilter:="Text Files (*.doc), *.doc")
If fileSaveName <> "Faux" Then
WordApp.Visible = True
WordDoc.SaveAs fileSaveName
WordApp.Activate
Else
WordDoc.Close False
WordApp.Quit
End If
End Sub |
Partager