how to get a file path without open the file from xldialog

[shaoxk66]

i want to get file's access path as string, not open the file.

the code should be like:

Dim msg As String

Application.FileDialog(msoFileDialogFolderPicker).Show
msg = Application.FileDialog(msoFileDialogFilePicker).SelectedItems(1)

by using this filedialog, i can only have folder's directory, but can not see any file.
can anybody give me an idea which built-in dialog i could use to get file path.

Thanks

 

[SkipVought]

Hi,

What APPLICATION?

Skip,

_{When a wee mystic is on the loose..
It's a Small Medium at Large!}

 

[shaoxk66]

excel vb application

 

[SkipVought]

Check out the GetOpenFilename Method

Skip,

_{When a wee mystic is on the loose..
It's a Small Medium at Large!}

 

[shaoxk66]

Skip,
Thanks so much. the function returns just what i want.

 

[rmikesmith]

I use GetOpenFilename myself, but if you wanted to use FileDialog you would do something like:

With Application.FileDialog(msoFileDialogFilePicker)
  .Show
  If .SelectedItems.Count > 0 Then
    MsgBox .SelectedItems(1)
  End If
End With

Regards,
Mike