On Thu, 29 Apr 2004 20:52:08 -0500, Dave Peterson wrote:

And when all your users are upgraded to xl2002, you can use this new featu

Application.FileDialog(msoFileDialogFolderPicker) .Show

(Look at VBA's help for lots more details.)

I tried it. I prefer the simpler folder browser that appears in the other
posted examples. I already implemented the first one posted. While it would
be nice to control the opening folder, the other examples where much more
complicated. I prefer to keep things simple. And the use for this is fairly
low, so not worth the trouble going beyond having it start from the
desktop.

Don <donwiss at panix.com.