Sub creationDossier()
Dim Chemin$
If [b4] = "" Or [b5] = "" Or [b7] = "" Then MsgBox "Fichier non enregistré." & vbLf & "Saisie manquante.", , "Information": Exit Sub
If Not CarFichInterdit([e4]) Then
Chemin = "C:\dossiers\perso\"
On Error Resume Next
Chemin = Chemin & [b7] & "\"
MkDir (Chemin)
On Error GoTo 0
ActiveWorkbook.SaveCopyAs Chemin & [e4] & ".xlsm"
Application.EnableEvents = False
[b4:b7] = "": Rows("8:11").Hidden = True
Application.EnableEvents = True
End If
End Sub
Public Function CarFichInterdit(F$) As Boolean
'**** Origine Roland M ****
CarFichInterdit = False
Car$ = "< > \ / | ? : * . " & Chr(34)
For I = 1 To 10
C$ = Choose(I, "<", ">", "\", "/", "|", "?", ":", "*", ".", Chr(34))
If InStr(F$, C$) Then
MsgBox "Fichier non enregistré." & vbLf & "Dans un nom de fichier," & vbLf & "les caractères suivants sont interdits !" & vbLf & vbLf & Car$, vbCritical, "Information"
CarFichInterdit = True
End If
Next
End Function