xlDialogOpen get it to return Path

[DMc2005]

Hi

How can i get the XLDialogOpen to return the path of the file. ie
C:\documents and users\someuser\my documents\test.xls

Thanks.

D

[Tom Ogilvy]

Instead use

Dim fName as String
fName = Application.GetOpenFileName()

fName will hold what you show.

--
Regards,
Tom Ogilvy

"DMc2005" <davidmcnaughton_1999_nospam@hotmail.com> wrote in message
news:esmUsL1xFHA.720@TK2MSFTNGP15.phx.gbl...
> Hi
>
> How can i get the XLDialogOpen to return the path of the file. ie
> C:\documents and users\someuser\my documents\test.xls
>
> Thanks.
>
> D
>
>