' Return the extension of a file nameFunction GetFileExtension(ByVal FileName As String) As String Dim i As Long For i = Len(FileName) To 1 Step -1 Select Case Mid$(FileName, i, 1) Case "." GetFileExtension = Mid$(FileName, i + 1) Exit For Case ":", "" Exit For End Select NextEnd Function