Simple get filename and foldername

[staticbob]

Guys, sorry, its been a while...

I need to get a filename from the user, and also store its folder. I was trying with this but I guess this dialogue just returns the filename, dont want to have to trim it...

'Select XML CA definition file
Set objDialog = CreateObject("UserAccounts.CommonDialog")
intResult = objDialog.ShowOpen
If Not intResult = 0 Then
str_xmlfilename = objDialog.filename
str_xmlfoldername = ""
End If

Whats the simple way of doing this?

Bob

[Hack]

I need to get a filename from the user, and also store its folder. I was trying with this but I guess this dialogue just returns the filename

I'm confused. You want to get a filename from the user but you don't want to use a control that returns the filename?

What am I missing here?

Also, what does "store its folder" mean? Lets say the filename is c:\folder\hack.txt

Do you want to store c:\folder in a variable or something?