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
|
Sub TestSauvegardeEnPdf()
Dim Fd As FileDialog
Dim vrtSelectedItem As Variant
Dim RepertoireChoisi As Variant
Dim NomFichier As String
'ChDir ActiveDocument.Path
NomFichier = InputBox("Entrez le nom du fichier sans son extension", "Sauvegarde des fichiers", Split(ActiveDocument.Name, ".")(0))
RepertoireChoisi = ""
Set Fd = Application.FileDialog(msoFileDialogFolderPicker)
With Fd
If .Show = -1 Then
Debug.Print vrtSelectedItem
For Each vrtSelectedItem In .SelectedItems
RepertoireChoisi = vrtSelectedItem
Next vrtSelectedItem
End If
End With
If RepertoireChoisi <> "" Then SauvegardeEnPdf ActiveDocument.Name, RepertoireChoisi, NomFichier
MsgBox "Fin de la copie !", vbInformation
Set Fd = Nothing
End Sub
Sub SauvegardeEnPdf(ByVal NomDuFichierDoc As String, ByVal RepertoireDeDestination As String, NomFichier2 As String)
Dim DocEnCours As Document
Dim NomWord As String, NomPdf As String, Extension As String
Dim Fso As Object
Set DocEnCours = Documents(NomDuFichierDoc)
NomPdf = RepertoireDeDestination & "\" & NomFichier2 & ".pdf"
DocEnCours.ExportAsFixedFormat OutputFileName:=NomPdf, ExportFormat:=wdExportFormatPDF, OpenAfterExport:=False
Set Fso = CreateObject("Scripting.FileSystemObject")
With Fso
Extension = .GetExtensionName(DocEnCours.FullName)
NomWord = RepertoireDeDestination & "\" & NomFichier2 & "." & Extension
.CopyFile DocEnCours.FullName, NomWord, True
End With
Set Fso = Nothing
Set DocEnCours = Nothing
End Sub |
Partager