Return Parent Directory for Files and Folders

This short snippet of code will return the parent directory of a directory input, or the directory of a filename input.

s = "C:\test drive\yeah\boo.htm"
i = InStrRev(s, "\")
s = Left(s, i)
MsgBox s

If the input is a directory (C:\Windows\System) it will return that directory's parent (C:\Windows\). If the input is a file (C:\Windows\System\icon.jpg) it will return that file's directory (C:\Windows\System\).

You might also like...


Michael Wales


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“The greatest performance improvement of all is when a system goes from not-working to working.” - John Ousterhout