VBA - Return File Path without Filename

[vba_monkey]

Hello,

Can anyone please tell me how to use Application.GetOpenFilename to return the filepath without the filename or is there a different way to do it?

Thanks

 

[BobUmlas]

Sub Answer()
z=Application.GetOpenFileName
Ans=Curdir
End Sub

 

[vba_monkey]

Can you explain please? What are z and ans and how do they relate to each other?

 

[Jaafar Tribak]

z is the string returned by GetOpenFileName containing the chosen File path and file name.
Ans is the Current Directory which is changed by the call to GetOpenFileName and which is also the filepath and that's what you want .