+ Reply to Thread
Results 1 to 10 of 10

list subfolders and files of main folder with details

  1. #1
    Registered User
    Join Date
    08-12-2014
    Location
    lisbon
    MS-Off Ver
    2010
    Posts
    4

    list subfolders and files of main folder with details

    Hello guys!
    I'm very new on programming but I'm enjoying it so far .
    I need help to make a vbs fil that returns
    SO FAR I HAVE THIS (but it doesn't return a counter of how many files nor separates the fields in different columns)

    Please Login or Register  to view this content.
    Thanks in advance all you guys!
    You'll have a very thankful girl posting here! :D
    Last edited by Paul; 08-13-2014 at 02:05 PM. Reason: Added CODE tags for new user. Please do so yourself in the future.

  2. #2
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: list subfolders and files of main folder with details

    Hi buerere and welcome to ExcelForum,

    When you post code, you need 'code tags'. See the forum rules for instructions:
    http://www.excelforum.com/forum-rule...rum-rules.html

    Please add code tags or you will get no other responses to your post.

    See the following thread. The file associated with post #2 will probably lead you in the right direction.
    http://www.excelforum.com/excel-prog...h-results.html

    Good luck.

    Lewis

  3. #3
    Registered User
    Join Date
    08-12-2014
    Location
    lisbon
    MS-Off Ver
    2010
    Posts
    4

    Re: list subfolders and files of main folder with details

    ** A vbs file that returns the list of subfolders and files contained in a main file, with their details **

  4. #4
    Valued Forum Contributor
    Join Date
    03-22-2013
    Location
    Australia,NSW, Wirrimbi
    MS-Off Ver
    Excel 2013
    Posts
    1,057

    Re: list subfolders and files of main folder with details

    Hi..

    with their details
    Which details exactly do you want..?

    Edit: Add code tags as directed in previous post.. to do this.. highlight you code and click the # icon in the Quick Reply menu bar..
    Last edited by apo; 08-13-2014 at 04:46 AM.

  5. #5
    Registered User
    Join Date
    08-12-2014
    Location
    lisbon
    MS-Off Ver
    2010
    Posts
    4

    Re: list subfolders and files of main folder with details

    Details:
    Name
    Size
    Last Date Modified
    number of files in each subfolder

  6. #6
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: list subfolders and files of main folder with details

    Please Login or Register  to view this content.
    will add the number of files in the folder to the end of the line

  7. #7
    Registered User
    Join Date
    08-12-2014
    Location
    lisbon
    MS-Off Ver
    2010
    Posts
    4

    Re: list subfolders and files of main folder with details

    thank you so much ragulduy!

  8. #8
    Valued Forum Contributor
    Join Date
    03-22-2013
    Location
    Australia,NSW, Wirrimbi
    MS-Off Ver
    Excel 2013
    Posts
    1,057

    Re: list subfolders and files of main folder with details

    Out of interest..

    Here's one that will do everything except your last bit (counting files in subfolders)...

    It would be interesting to see if the last requirement could be added to it..

    Please Login or Register  to view this content.

  9. #9
    Registered User
    Join Date
    06-06-2014
    Posts
    9

    Re: list subfolders and files of main folder with details

    Hi

    i need a similar code for the following work

    everyday a new sub folder is created in my parent folder D:\XYZ ...

    1) Insert the name of sub folder in Col A (Cell 1)
    2)Count the number of files in Subfolder [ Col B Cell 2)

    Next day shift this row to down and do the same

  10. #10
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: list subfolders and files of main folder with details

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

    ---------------------

    Please post your question in a new thread. You can put a link to this thread if you like.

    Lewis

+ 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] list of subfolders in folder - without files and sub-subfolders
    By MartyZ in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-11-2022, 10:56 AM
  2. Sum excel files in one folder to a main document outside of the folder
    By patel.1557 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-23-2014, 08:27 AM
  3. Macro to rename photos in a main folder's subfolders to subfolder names
    By Spardante in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-22-2014, 11:41 PM
  4. Adapt macro to create list of all PDF files in folder, including subfolders.
    By Glensafro in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-23-2013, 06:33 AM
  5. Counting files in folder including subfolders also and folder size
    By mido609 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-12-2012, 03:26 PM

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