View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Using a "File-Open"-Window in a Excel Macro?

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/