Description: Returns the name of the
file specified by the path name (directory name). Use the FileIndex
parameter to specify which file you would like to return (the first,
second, third, etc). Equivalent to the Visual Basic Dir function.
PathName : Name of the directory containing the
file FileIndex : Optional. Index of the file to return. Attributes :
Optional. A constant to specify the type of file to find. 0 (default) are
normal files, 1 denote read-only files, 2 specified hidden files, 4
specifies system files, 8 specifies volume names, 16 specifies directory
names, 64 denotes Macintosh Aliases.
You can combine the attributes by adding the
particular attribute constants together. E.g. the attribute value of 1+2=3
denotes read-only system files.
Example:
Find the first file in
C:\ =Dir("c:\*.*",1)
Find the second file in
C:\ =Dir("c:\*.*",2)
Find the third file in
C:\ =Dir("c:\*.*",3)
Copyright (C) 1995-2007 Linker IT
Software BV. All Rights Reserved. Oracle is a registered trademark of
Oracle corporation. Excel and Office are registered trademarks of
Microsoft corporation. Other names appearing on the site may be trademarks
of their respective owners. Software,
files, documents, articles and other material are provided
"as is" and without warranties as to performance or mechantability or
any other warranties whether expressed or implied. No
warranty of fitness for a particular purpose is offered.
sitemap
