Function FromQwerty(str) Dim d, s, t, i, c, r s = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ" t = "qwertyuiopasdfghjklzxcvbnmQWERTYUIOPASDFGHJKLZXCVBNM" Set d = CreateObject("Scripting.Dictionary") For i = 1 To 52 d(Mid(t, i, 1)) = Mid(s, i, 1) Next For i = 1 To Len(str) c = Mid(str, i, 1) If d.Exists(c) Then r = r & d(c) Else r = r & c End If Next FromQwerty = r End Function
Function ToQwerty(str) Dim d, s, t, i, c, r s = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ" t = "qwertyuiopasdfghjklzxcvbnmQWERTYUIOPASDFGHJKLZXCVBNM" Set d = CreateObject("Scripting.Dictionary") For i = 1 To 52 d(Mid(s, i, 1)) = Mid(t, i, 1) Next For i = 1 To Len(str) c = Mid(str, i, 1) If d.Exists(c) Then r = r & d(c) Else r = r & c End If Next ToQwerty = r End Function