Excel Hack 89: Extract file names from a folder into Microsoft Excel
Have you had to work with a folder containing lots of documents, and you wanted to get the list of all the documents? This may be a directory listing all the policy documents in the organization, or the CVs of job candidates, or PDF forms filled by several employees. If you needed to get a