Open folder selection box and getting path of file

[yummy]

From an excel file macro, I want to open a "folder selection box" using VBA and select a file (excel file).
(Ideally, it should give an error if any other file than excel file is selected)

Then I want to get the path of any file selected through this selection box

lets say the path returned was
"C:\Documents and Settings\MyExcelsheet.xls"

So that I can set the path like this
Set wbk = Workbooks.Open("C:\Documents and Settings\MyExcelsheet.xls")

Would appreciate any help

Regards

 

[MickG]

See "FileDialog Object " in Vb Help.

 

[yummy]

Thanks so much

I was able to do what I wanted by looking at help you mentioned