+ 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. 10-31-2018, 02:23 AM #1
    EvelynLoh
    EvelynLoh is offline
    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.
    Reply With QuoteRegister To Reply
  2. 10-31-2018, 02:35 AM #2
    kersplash
    kersplash is offline
    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?
    Reply With QuoteRegister To Reply
  3. 10-31-2018, 03:03 AM #3
    EvelynLoh
    EvelynLoh is offline
    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
    Reply With QuoteRegister To Reply
  4. 10-31-2018, 03:05 AM #4
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2505 (Windows 11 Home 24H2 64-bit)
    Posts
    91,310

    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" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  5. 10-31-2018, 03:27 AM #5
    mohan.r1980
    mohan.r1980 is offline
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    729

    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
    Reply With QuoteRegister To Reply
  6. 11-02-2018, 03:15 AM #6
    EvelynLoh
    EvelynLoh is offline
    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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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. Copy cells of all files starting with PJ from folders and sub folders to master document
    By RoyLittle0 in forum Excel Programming / VBA / Macros
    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. 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1