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
|
Option Explicit
Public Repertoire As String, FichierNouveauNom As String, FichierProvisoire As String
Sub OuvrirFichierLectureSeuleRecommandee()
Dim Fd As FileDialog
Dim VrtSelectedItem As Variant
Repertoire = "C:\Users\Eric\Downloads\"
FichierNouveauNom = ""
ChDir Repertoire
Set Fd = Application.FileDialog(msoFileDialogFilePicker)
With Fd
If .Show = -1 Then
For Each VrtSelectedItem In .SelectedItems
FichierNouveauNom = VrtSelectedItem
Next VrtSelectedItem
End If
End With
If FichierNouveauNom <> "" Then
Select Case LCase(Split(FichierNouveauNom, ".")(1))
Case "docx"
FichierProvisoire = "Fichier provisoire.docx"
Case "docm"
FichierProvisoire = "Fichier provisoire.docm"
End Select
Documents.Open FileName:=FichierNouveauNom, _
ConfirmConversions:=False, ReadOnly:=True, AddToRecentFiles:=False, _
PasswordDocument:="", PasswordTemplate:="", Revert:=False, _
WritePasswordDocument:="", WritePasswordTemplate:="", Format:= _
wdOpenFormatAuto, XMLTransform:=""
With ActiveDocument
.ReadOnlyRecommended = False
End With
ActiveDocument.SaveAs2 FileName:= _
Repertoire & FichierProvisoire, FileFormat:= _
wdFormatXMLDocument, LockComments:=False, Password:="", AddToRecentFiles _
:=True, WritePassword:="", ReadOnlyRecommended:=False, EmbedTrueTypeFonts _
:=False, SaveNativePictureFormat:=False, SaveFormsData:=False, _
SaveAsAOCELetter:=False, CompatibilityMode:=14
End If
Set Fd = Nothing
End Sub |
Partager