I need to use a dialog to select, or create and select a folder. I'm using the GetOfficeFileName routine from the Access Developer's Handbook to get filenames, but I can't seem to get it to select just a path\folder name, without having to select or point to an actual file. Anyone familiar with this routine and the various flags?
.strDlgTitle = "Specify the path for the subscription export files:"
' .strOpenTitle = "Save"
.strInitialDir = "S:\CPE\" & Me.ItemSched.Column(3) & "\"
.lngFlags = GfniDirectoryOnly
If OfficeGetFileName(gfni, 0) = ErrSuccess Then
SelectPath = gfni.strFile