Hi All
On a userform I have a textbox control in which I let the user store the
destination directory for the file(s) created. I have been using
Application.GetOpenFilename to let the user go and find the directory and
choose a file - I then strip the filename leaving the path only and put this
in the control.

It is not elegant since the user has to choose a file to open (anyone will
do) so I can extract the path, problem #1 is that user is now being asked to
open a file which doesn't actually happen just so I can get the directory -
all a bit confusing for them (and me!).

Aside from that, if the directory is empty there are no files to select - so
problem #2 they cannot select this directory.

Anyone got a solution please?

--
Cheers
Nigel