Contents

# Dir Function

傳回與指定的搜尋路徑相符的磁碟機或目錄中的某個檔案、某個目錄或所有檔案和目錄的名稱。

### Syntax:

    Dir [(PathName As String [, Attributes As Integer])]

### Return type:

字串型

### Parameters:

PathName: Any string expression that specifies the search path, directory or file. This argument can only be specified the first time that you call the Dir function. If you want, you can enter the path in URL notation.

Attributes:Any integer expression that specifies bitwise file attributes. The Dir function only returns files or directories that match the specified attributes. You can combine several attributes by adding the attribute values:

0 : 一般檔案。

16 : 僅傳回目錄的名稱。

使用此屬性來檢查檔案或目錄是否存在，或者確定指定目錄下的所有檔案或資料夾。

若要檢查檔案是否存在，請輸入檔案的完整路徑和名稱。如果檔案或目錄名稱不存在，Dir 函式將傳回一個零長度字串 ("")。

To generate a list of all existing files in a specific directory, proceed as follows: The first time you call the Dir function, specify the complete search path for the files, for example, "D:\Files\*.ods". If the path is correct and the search finds at least one file, the Dir function returns the name of the first file that matches the search path. To return additional file names that match the path, call Dir again, but with no arguments.

To return directories only, use the attribute parameter. The same applies if you want to determine the name of a volume (for example, a hard drive partition).

### 錯誤代碼：

5 無效的程序呼叫

53 找不到檔案

### Example:

    Sub ExampleDir
    REM 顯示所有檔案和目錄
    Dim sPath As String
    Dim sDir As String, sValue As String
        sDir="Directories:"
        sPath = CurDir
        sValue = Dir$(sPath + getPathSeparator + "*",16)
        Do
            If sValue <> "." And sValue <> ".." Then
                If (GetAttr( sPath + getPathSeparator + sValue) And 16) >0 Then
                    REM 獲取目錄
                    sDir = sDir & chr(13) & sValue
                End If
            End If
            sValue = Dir$
        Loop Until sValue = ""
        MsgBox sDir,0,sPath
    End Sub

相關主題

CurDir Function

CompatibilityMode() Function

Option VBASupport Statement