Private Sub Command1_Click()
Dim LaRuta As String
LaRuta = InputBox("Ingrese la ruta de la carpeta", "Ingresar")
'MsgBox ExisteCarpeta(LaRuta)
MsgBox ExisteCarpeta(StrConv(Trim(LaRuta), vbProperCase))
End Sub
Function ExisteCarpeta(Ruta As String) As String
If Dir(Ruta, vbDirectory) <> "" Then
ExisteCarpeta = "La carpeta existe"
Else
ExisteCarpeta = "La carpeta no existe"
End If
End Function