Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
SQL*XL: Database to Excel bridge ExcelLock: Lock and secure your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe
Home Products litLIB Help Filesystem functions

Buy now

Download now

LITlib - Excel Power Functions Pack
 
Add-in for Excel that adds additional cell functions to Excel.

litLIB Help - FileAttribute function
litLIB Help
Product pages :
litLIB
Quick links:
help index
forums

File System - FileAttribute 

Syntax:
=FileAttribute(File, Optional Options)

Description:
Returns the file attributes of the given file.

File : Full path to the file for which the attributes should be returned
Options : Optional. 0 returns true or false for an attribute, 1 (default) returns + or - to denote if an attribute is switched on or not. 2 denotes that the attribute name should be returned only if the attribute is set. A value of 3 specifies the name of the attribute to be upper case if set and lower case when it is not set.

Example:
Determine the attributes of the c:\msdos.sys file. Output: -N+R+H+S-D+A

=FileAttribute("c:\msdos.sys")

litLIB