Option Explicit
' Définition de la conversion
Const Accent As String = "ÀÁÂÃÄÅàáâãäåÒÓÔÕÖØòóôõöøÈÉÊËèéêëÌÍÎÏìíîïÙÚÛÜùúûüÿÑñÇç"
Const noAccent As String = "AAAAAAaaaaaaOOOOOOooooooEEEEeeeeIIIIiiiiUUUUuuuuyNnCc"
' La fonction :
Public Function SansAccents(ByRef s As String) As String
Dim i As Integer
Dim lettre As String * 1
SansAccents = s
For i = 1 To Len(Accent)
lettre = Mid$(Accent, i, 1)
If InStr(SansAccents, lettre) > 0 Then
SansAccents = Replace(SansAccents, lettre, Mid$(noAccent, i, 1))
End If
Next i
End Function