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:\")
Copyright (C) 1995-2010 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
