Attribute VB_Name = "VCS_Dir" Option Compare Database Option Private Module Option Explicit ' Path/Directory of the current database file. Public Function ProjectPath() As String ProjectPath = CurrentProject.Path If Right$(ProjectPath, 1) <> "\" Then ProjectPath = ProjectPath & "\" End Function ' Path/Directory for source files Public Function SourcePath() As String SourcePath = ProjectPath & CurrentProject.name & ".src\" End Function ' Create folder `Path`. Silently do nothing if it already exists. Public Sub MkDirIfNotExist(ByVal Path As String) On Error GoTo MkDirIfNotexist_noop MkDir Path MkDirIfNotexist_noop: On Error GoTo 0 End Sub ' Delete a file if it exists. Public Sub DelIfExist(ByVal Path As String) On Error GoTo DelIfNotExist_Noop Kill Path DelIfNotExist_Noop: On Error GoTo 0 End Sub ' Erase all *.`ext` files in `Path`. Public Sub ClearTextFilesFromDir(ByVal Path As String, ByVal Ext As String) Dim FSO As Object Set FSO = CreateObject("Scripting.FileSystemObject") If Not FSO.FolderExists(Path) Then Exit Sub On Error GoTo ClearTextFilesFromDir_noop If Dir$(Path & "*." & Ext) <> vbNullString Then FSO.DeleteFile Path & "*." & Ext End If ClearTextFilesFromDir_noop: On Error GoTo 0 End Sub Public Function DirExists(ByVal strPath As String) As Boolean On Error Resume Next DirExists = False DirExists = ((GetAttr(strPath) And vbDirectory) = vbDirectory) End Function Public Function FileExists(ByVal strPath As String) As Boolean On Error Resume Next FileExists = False FileExists = ((GetAttr(strPath) And vbDirectory) <> vbDirectory) End Function