Excel GetAttr Function (VBA)
-function/getattr-function-vba-code.jpg)
How to use the GetAttr Function (VBA)
This Excel tutorial explains how to use the Excel GetAttr function with syntax and examples using VBA.
SUMMARY:
The Excel VBA GetAttr function returns an Integer representing the attributes of a file, directory, or folder.
The Integer value can be a single attribute or a combination of multiple attributes (sum).
PURPOSE:
To get the attributes information for.
RETURN VALUE:
The GetAttr function returns an integer value.
SYNTAX:
GetAttr(pathname)
ARGUMENTS:
The GetAttr function syntax has the following arguments:
- pathname: Required. The pathname argument is a string expression that specifies a file name.
- The pathname may include the directory or folder, and the drive.
- The value returned by GetAttr is the sum of the following attribute values:
Constant Value Description vbNormal 0 (Default) Specifies Normal files. vbReadOnly 1 Specifies read-only files. vbHidden 2 Specifies hidden files. vbSystem 4 Specifies system files. Not available on the Macintosh. vbDirectory 16 Specifies directories or folders. vbArchive 32 File has changed since last backup. Not available on the Macintosh. vbAlias 64 Specified file name is an alias. Available only on the Macintosh.
REMARKS:
- If the specified file is not available then an error will occur.
- To determine which attributes are set, use the And operator to perform a bitwise comparison of the value returned by the GetAttr function and the value of the individual file attribute you want. If the result is not zero, that attribute is set for the named file.
Diffrent way to use the GetAttr function using Excel VBA Code...
-function/getattr-function-vba-code-remark1.jpg)
GetAttr Function Example (as VBA code)
The GetAttr function can only be used in VBA code in Microsoft Excel.The following VBA code shows how the GetAttr function used to get the attribute values of an path.
Dim testResult As Integer
testResult = GetAttr("C:\myprofile.jpg")
In the above VBA code example, The testResult variable would now contain the integer representation of the attributes of the myprofile.jpg file.
VBA GetAttr Function Error:
If you supply invalid path/name of the file to the GetAttr function, you will get the error:Run-time error '76': Path not found
-function/getattr-function-error-path-not-found.jpg)