+ Reply to Thread
Results 1 to 6 of 6

Macro to list all the files in folders and display who is the authors of files in Folders

  1. #1
    Forum Contributor
    Join Date
    11-07-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    100

    Macro to list all the files in folders and display who is the authors of files in Folders

    Hi All expert,

    I need to download the list of files in my harddisk into Excel and able to list out the author name of the individual files too.

    May I know how to write the VBA code to list out the files with the Author name list out in Excel?

    Thank you.

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Macro to list all the files in folders and display who is the authors of files in Fold

    Do you have Excel 2003?

  3. #3
    Forum Contributor
    Join Date
    11-07-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    100

    Re: Macro to list all the files in folders and display who is the authors of files in Fold

    No.. only 2007

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, Suffolk (England), but grew up in Sawley, Derbyshire
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2211 (Windows 11 22H2 64-bit)
    Posts
    65,444

    Re: Macro to list all the files in folders and display who is the authors of files in Fold

    Then please update your forum user profile to reflect this - it currently says 2003.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  5. #5
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    728

    Re: Macro to list all the files in folders and display who is the authors of files in Fold

    Hi,

    i got attached file from this forum.
    it wil help you
    Please find the attached file
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    11-07-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    100

    Re: Macro to list all the files in folders and display who is the authors of files in Fold

    Hi

    I appreciate your help. However... this file does not list out whose the "Author" of the file as in creator of the file.

    Anyway to add in a column to display?

    Thank you.

+ 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. [SOLVED] macro to list files in folder and sub folders has stopped working
    By Lmel0611 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-29-2015, 09:12 PM
  2. Create folders and save text files to these folders
    By bloomingcarrot in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-03-2014, 08:14 PM
  3. Use Excel VBA to Copy multiple files from different source folders to different folders
    By mm1234mail in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-12-2014, 01:17 PM
  4. Replies: 1
    Last Post: 09-12-2013, 09:23 PM
  5. Recursively Count Files in Folders and Sub-Folders
    By cdeshaz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-01-2013, 01:15 PM
  6. Create folders and move and copy files into that folders
    By vijaybharthi in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-31-2010, 04:01 AM
  7. [SOLVED] change display format for excel folders and files
    By inthestands in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-15-2006, 08:10 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