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 - Dir function
litLIB Help
Product pages :
litLIB
Quick links:
help index
forums

File System - FileNames

Syntax:
=FileNames(Directory)

Array function.
To use this function select a range of cells (e.g. 1 column and 10 rows). Type the function and press Ctrl+Shift+Enter

Description:
Returns the names of the files in the directory.

Directory: Name of the directory containing the files

Example:

=FileNames("c:\")


litLIB