FileDialog to select file

[Acid-Sky]

Hi,

I am trying to add a FileDialog to my form but its only t
select/generate a correct filepath, nothing more. the only options
saw so far tend to open the file - which is not what i want. the dialo
is more the make sure the file path is correct and the file exists a
the time of genereating an entry.

how can i do this

 

[Bernie Deitrick]

Application.GetOpenFileName only returns a string, which you can save or manipulate in any way you
want.

 

[Dave Peterson]

Jim Rech has a BrowseForFolder routine at:
http://www.oaltd.co.uk/MVP/Default.htm
(look for BrowseForFolder)

John Walkenbach has one at:
http://j-walk.com/ss/excel/tips/tip29.htm

If you and all your users are running xl2002+, take a look at VBA's help for:
application.filedialog(msoFileDialogFolderPicker)