Option Explicit
Function NomFeuilleValide(ByVal Nom As String) As String
Const CaracInterdits As String = ":/\?*[]"
Dim i As Integer, Car As String * 1
Nom = Trim(Nom)
For i = 1 To Len(CaracInterdits)
Car = Mid$(CaracInterdits, i, 1)
Nom = Replace(Nom, Car, "")
Next
Select Case Len(Nom)
Case 0: Exit Function
Case Is > 31: Nom = Left$(Nom, 31)
End Select
NomFeuilleValide = Nom
End Function