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.