file Pick - name only not path

[CData]

hi again,

I have FileDialog code that results in the full path ...\folderA\folderB\MyDatabase.accdb

The user needs to browse / file explore to find the correct accdb - - - but what then what is needed to save is only the file name: MyDatabase.accdb

I can string parse that by finding the last "\" symbol
but I was wondering if there was a property in FileDialog method that provided it? ...without the path

have googled about quite a bit but can't seem to zero in on that question....

[HansV]

No, the FileDialog always returns the path + filename. So you'll have to parse the string, or use the Dir function: Dir(path + filename) returns just filename.

[CData]

Dir() works great! thanks for the tip.