I'm using Excel 2000 and I would like to bring up a dialog box that allows the user to select a Path. Does anyone have a solution for this? I've looked at a few API calls but none of them do specifically what I'd like...

Any ideas on how to accomplish this? Up until now I've been using either a textbox to type in the path or a file open dialog box and asking the user to open a file in the directory that wish to select.

Thanks,

Dave