Results 1 to 5 of 5

Thread: How can I create hyperlink list of folders and files in a directory in excel

  1. #1
    Neophyte Stevenegoad's Avatar
    Join Date
    Jun 2013
    Location
    Broken Arrow, Oklahoma
    Posts
    3
    Articles
    0

    How can I create hyperlink list of folders and files in a directory in excel



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have a folder(instruction bulletins) that contains dozens of folders(manufactures) with each containing dozens of folders(devices) and dozens of PDF files(manuals) and I wish to create a excel workbook that contains hyperlinks to all of these PDF files so that I can search through them and click on a hyperlink which will take me to the PDF file.

  2. #2
    Conjurer royUK's Avatar
    Join Date
    Mar 2011
    Location
    Derbyshire, UK
    Posts
    155
    Articles
    0
    Excel Version
    most versions
    See this
    Hope that helps

    Roy

  3. #3
    Neophyte Stevenegoad's Avatar
    Join Date
    Jun 2013
    Location
    Broken Arrow, Oklahoma
    Posts
    3
    Articles
    0
    Thanks but this does not get the sub folders and their files.

  4. #4
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    681
    Articles
    0
    Excel Version
    Excel 2010 64bit
    The code here may be something to have a look at.

  5. #5
    Neophyte Stevenegoad's Avatar
    Join Date
    Jun 2013
    Location
    Broken Arrow, Oklahoma
    Posts
    3
    Articles
    0
    Thanks as this is what I was looking for plus some!

Posting Permissions

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