Many thanks to you all for your help.

"Gordon Rodman" wrote in message
...
I am developing a userform that will allow a user to change thie working
directory for a particular project. Does anyone know if there is something
similar to getfileopen that will return a directory rather than a
file?Alternatively does anyone have any bright ideas how I could use
getfileopen to achieve my desired result?

Regards

Gordon Rodman