how to retrieve path

i want to retrieve the path if the particular filename is given.Also,if i give the particular folder name,the path for that folder must be displayed.is it possible using vbcoding.provide coding for both .

What do you need? The user to type in a filename, and you just extract the path from the full filename?

VB Code:

'Megatron gave this to me a long time ago
FileName = "C:\Windows\file"
FileName = Left(FileName, InStrRev(FileName, "\"))
MsgBox FileName