Returns the attributes of a given file or directory (Integer).
|pathname||The full pathname of the file you want to examine (String).|
|* The "pathname" may include a directory and drive.|
* The value returned is a sum of the following values: 0 = vbNormal. 1 = vbReadOnly. 2 = vbHidden. 4 = vbSystem. 16 = vbDirectory. 32 = vbArchive (Macintosh only).
* The easiest way to find out which attributes are set is to use the AND operator to perform a bitwise comparison of the value and the value of the individual file attribute (result = GetAttr(sFileName) And vbArchive.
* The equivalent .NET function is Microsoft.VisualBasic.FileSystem.GetAttr
* For the Microsoft documentation refer to docs.microsoft.com
If (GetAttr("C:\temp\myfile.docx") = VBA.vbArchive + VBA.vbReadOnly) Then
If (GetAttr("C:\temp\myfile.docx") = 32) Then
© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top