RE: Ruta en ms2
Copia este código en un módulo público
Option Explicit
Declare Function GetShortPathName Lib "kernel32" Alias "GetShortPathNameA" (ByVal lpszLongPath As String, ByVal lpszShortPath As String, ByVal cchBuffer As Long) As Long
Public Function ShortPathName(filename As String) As String
On Local Error Resume Next
Dim shortname As String
Dim waste As Long
shortname = String(255, " "

: waste = Len(shortname)
waste = GetShortPathName(filename, shortname, waste)
ShortPathName = shortname
End Function
Shortpayhname te devolverá una cadena con la ruta corts (MSDOS) del fichero solicitado.
Te adjunto un ejemplo para que lo pruebes.
Un cordial saludo
-Acalanto-