Instead use

Dim fName as String
fName = Application.GetOpenFileName()

fName will hold what you show.

--
Regards,
Tom Ogilvy

"DMc2005" wrote in message
...
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