I am using a common dialog box on a form and want to get the path to a
directory. I have

Private Sub GetdataDir()
CommonDialog2.InitDir = "C:\my databases\"
CommonDialog2.DialogTitle = "Browse for Datafile directory"
CommonDialog2.Filter = "Data files directory (*.*)|*.*"
CommonDialog2.DefaultExt = ".*"
CommonDialog2.ShowOpen
TextBox26.Value = CommonDialog2.filename
End Sub
Which works OK for getting files but can I use it to get the directory path
only eg c:\my databases\

Also is there a way to allow slection of multiplefiles?

Thanks
Chris