View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Martin Martin is offline
external usenet poster
 
Posts: 336
Default Explorer Window.

Have you tried:
FName = Application.GetOpenFilename("Excel Files (*.xls), *.xls")

"Brad" wrote:

Thanks for taking the time to read my question.

I would like to have a button in my workbook that when clicked opens up an
explorer window and allows the user to select a folder. When the folder is
selected, it would paste the path into a cell on one of the worksheets. I
have some code like this that works in Access, but I can't get it to work in
Excel, and can't find any code for Excel.

Any suggestions?

Thanks,

Brad