Look at GetOpenFilename in VBA Help.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"PeterBrinkrolf " wrote in
message ...
Hey Ya,
How can I display a window similar to the "File-Open" one within a
Excel-Macro to make the user selecting a file?
I am looking for any more convenient method to get a filename than
using a InputBox in which the user had to type the complete filename
including it's path...
Thanks!
Peter
---
Message posted from http://www.ExcelForum.com/