C0nverting MS-DOS Name to Full Name 1

[Ed2020]

Hi,

I am using the MS Access Scanning Tool from Micro$oft to scan servers at work for MS Access databases.

Rather helpfully the directory names in the filepaths are all MS-DOS names, not the full name as it appears in Explorer.

Does anyone know a way of converting these back to the full name again?

TIA,

Ed Metcalfe.

Please do not feed the trolls.....

 

[DrJavaJoe]

See

http://www.freevbcode.com/ShowCode.asp?ID=1133

Two strings walk into a bar. The first string says to the bartender: 'Bartender, I'll have a beer. u.5n$x5t?*&4ru!2[sACC~ErJ'. The second string says: 'Pardon my friend, he isn't NULL terminated'.

 

[Ed2020]

Superb. Thanks!

Ed.

Please do not feed the trolls.....

 

[strongm]

Or - if you've got shell32.dll version 5.0 or later (Windows Me, W2000, XP, W2003) - just add a reference to Shell Controls and Automation and use:

With New Shell32.Shell
Debug.Print .NameSpace("C:\progra~1").Self.Path
End With