FileDialog to select file

Hi,

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

how can i do this?

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

--
HTH,
Bernie
MS Excel MVP


"Acid-Sky" <[email protected]> wrote in message
news:[email protected]...
>
> Hi,
>
> I am trying to add a FileDialog to my form but its only to
> select/generate a correct filepath, nothing more. the only options i
> saw so far tend to open the file - which is not what i want. the dialog
> is more the make sure the file path is correct and the file exists at
> the time of genereating an entry.
>
> how can i do this?
>
>
> --
> Acid-Sky
> ------------------------------------------------------------------------
> Acid-Sky's Profile: http://www.excelforum.com/member.php...o&userid=26502
> View this thread: http://www.excelforum.com/showthread...hreadid=466815
>

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)

Acid-Sky wrote:
>
> Hi,
>
> I am trying to add a FileDialog to my form but its only to
> select/generate a correct filepath, nothing more. the only options i
> saw so far tend to open the file - which is not what i want. the dialog
> is more the make sure the file path is correct and the file exists at
> the time of genereating an entry.
>
> how can i do this?
>
> --
> Acid-Sky
> ------------------------------------------------------------------------
> Acid-Sky's Profile: http://www.excelforum.com/member.php...o&userid=26502
> View this thread: http://www.excelforum.com/showthread...hreadid=466815

--

Dave Peterson