+ Reply to Thread
Results 1 to 4 of 4

List of Files in Folder and sub folder

  1. #1
    Forum Contributor
    Join Date
    12-18-2019
    Location
    chennai
    MS-Off Ver
    excel 2010
    Posts
    141

    List of Files in Folder and sub folder

    Hi

    The below code is from some other website. I was using this code list out files in folder and sub folder with Hyperlink.
    The code is working fine. the code is currently updating

    Main Folder in one row
    then Sub Folder in one row
    then one next row its updating Hypherlink
    same row next column date modified.

    can some one help me to put all this in same row.
    First column for folder,
    second column is for sub folder
    third column for hypherlink
    next column for date modified.

    Please help


    Please Login or Register  to view this content.

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,015

    Re: List of Files in Folder and sub folder

    .
    The code, as is, does what you are seeking ... see attached.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    05-25-2020
    Location
    Madurai
    MS-Off Ver
    Excel 2010
    Posts
    136

    Re: List of Files in Folder and sub folder

    Hi Logit,
    I wrongly posted sorry for that

  4. #4
    Forum Contributor
    Join Date
    12-18-2019
    Location
    chennai
    MS-Off Ver
    excel 2010
    Posts
    141
    Quote Originally Posted by Logit View Post
    .
    The code, as is, does what you are seeking ... see attached.

    I Lohit

    If you see your attachment, folder name showing in first row only not every row. I am seeking help of updating folder and SUBFOLDER in every row as separate column.

    Example colum A for list of files hyperlink
    Column B for main Folder
    Column C for sub folders
    Column d for date modified

    Like that

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 12-11-2019, 04:37 AM
  2. [SOLVED] Trouble Updating a list of Files if a file no longer exists in the Folder/Sub Folder Dir.
    By jrtraylor in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-26-2019, 02:03 AM
  3. Copy Files from One Folder to Another Folder based on a List In Excel
    By civram1982 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-21-2019, 06:34 AM
  4. [SOLVED] Macro to list and open .xlsm files in folder and sub-folder
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-24-2019, 07:35 PM
  5. Replies: 1
    Last Post: 01-28-2019, 06:55 PM
  6. [SOLVED] Creating new folder, copying files and renaming files in folder
    By LionelNZ in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-24-2015, 04:18 PM
  7. Replies: 1
    Last Post: 01-24-2006, 11:00 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1