Can I find a FILE path with BrowseForFolder?

[OmandA]

Hello! Is there any way to use the Shell.Application function BrowseForFolder (or any other function for that matter) to browse for the path to a FILE as opposed to just a folder?

Here is the Syntax I'm presently using to browse for a FOLDER. I want something similar for finding a string that represents the path to a file.

Dim FolderPath As String
Dim SA As Object, F As Object
Set SA = CreateObject("Shell.Application")
Set F = SA.BrowseForFolder(0, "Choose a folder", _
0, strStartDir)
If (Not F Is Nothing) Then
FolderPath = F.Items.Item.Path
End If

...

Thanks in advance.

 

[Remou]

Have you seen, for example:
File Selecter
thread705-1069347

 

[OmandA]

Thanks... I've now reviewed that thread... but it's quite vague in it's references. Could you please give me an example of how to use the Application.FileDialog function?

 

[OmandA]

Disregard my last... I found a comprehensive example here:

http://tek-tips.com/viewthread.cfm?qid=1103022&page=1

(note: for anyone else who is curious and follows this link... scroll down... there is a useful and quick example at the BOTTOM of the thread - from "mp9")

 

[Remou]

Well, here is Microsoft on the subject:
Using the FileDialog Objects

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnoxpta/html/odc_filedlgobjs.asp

[tt]Application.FileDialog(FileDialogType:=msoFileDialogOpen).Filters.Add _
Description:="Word Documents (*.doc)", _
Extensions:="*.doc"[/tt]

 

[Remou]

And more from Tek-Tips:
Get File Using File DIalog
thread705-1129229