Results 1 to 1 of 1

Thread: List File Names Using Formula

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10

    Lightbulb List File Names Using Formula

    Hi All

    Here is a method to list the files names from a directory.

    Write down the directory name in a cell (for example in E1 on Sheet1 : C:\My Documents\). Don't forget to add '\' at the end.
    Then define a Name using Name Manager.

    Hit CTRL+F3 to open the Name Manager dialogbox:

    1. Click on New
    2. Give a name (for example PDF_Files) in the Name box
    3. In the Refers to box, type =FILES(Sheet1!$E$1&"*.PDF"). (Replace '.PDF' with the file extension you want)
    4. Click OK.

    Now enter this formula in A2 and copied down,

    =IFERROR(INDEX(PDF_Files,ROWS($A$2:A2)),"")

    If you want to hyperlink these files, use the following folrmula

    =IFERROR(HYPERLINK($E$1&INDEX(PDF_Files,ROWS($A$2:A2)),INDEX(PDF_Files,ROW S($A$2:A2))),"")
    Last edited by Admin; 09-20-2013 at 03:44 PM.
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

Similar Threads

  1. Data Validation With Dynamic List Of Sheet Names
    By TomyLee in forum Excel Help
    Replies: 2
    Last Post: 08-19-2013, 02:40 AM
  2. List File name in folder to excel with images
    By Ryan_Bernal in forum Excel Help
    Replies: 2
    Last Post: 01-15-2013, 11:37 AM
  3. List all Worksheet Names Using Formula
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 6
    Last Post: 12-17-2012, 02:47 AM
  4. List Unique Values Using Formula
    By LalitPandey87 in forum Excel Help
    Replies: 5
    Last Post: 01-09-2012, 08:39 PM
  5. Delete Names In A Specific Worksheet
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 08-14-2011, 02:38 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •