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
|