ExcelBanter - xlDialogOpen get it to return Path

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - xlDialogOpen get it to return Path (https://www.excelbanter.com/excel-discussion-misc-queries/48149-xldialogopen-get-return-path.html)

DMc2005

xlDialogOpen get it to return Path

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" 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

All times are GMT +1. The time now is 01:53 AM.