Table of contents
Collapse the table of content
Expand the table of content

SetAttr Statement

office 365 dev account|Last Updated: 6/12/2017
1 Contributor

Sets attribute information for a file.


SetAttrpathname, attributes

The SetAttr statement syntax has thesenamed arguments:

pathnameRequired. String expression that specifies a file name — may include directory or folder, and drive.
attributesRequired. Constant ornumeric expression, whose sum specifies file attributes.

Settings The attributesargument settings are:

vbNormal0Normal (default).
vbSystem4System file. Not available on the Macintosh.
vbArchive32File has changed since last backup.
vbAlias64Specified file name is an alias. Available only on the Macintosh.

Note These constants are specified by Visual Basic for Applications. The names can be used anywhere in your code in place of the actual values.

Remarks A run-time error occurs if you try to set the attributes of an open file.


This example uses the SetAttr statement to set attributes for a file. On the Macintosh, only the constants vbNormal, vbReadOnly, vbHidden and vbAlias are available.

SetAttr "TESTFILE", vbHidden ' Set hidden attribute. 
SetAttr "TESTFILE", vbHidden + vbReadOnly ' Set hidden and read-only 
 ' attributes. 
© 2018 Microsoft