xlDialogOpen get it to return Path

DMc2005 · Oct 2, 2005

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 · Oct 2, 2005

Instead use

Dim fName as String
fName = Application.GetOpenFileName()

fName will hold what you show.