+ Reply to Thread
Results 1 to 3 of 3

Copy folder names to Excel File

  1. #1
    Registered User
    Join Date
    04-05-2012
    Location
    KP
    MS-Off Ver
    Excel 2016
    Posts
    67

    Copy folder names to Excel File

    Hi,
    Thanks a lot for checking my thread. I have around 2500 folders and i want to copy their names (folder names) to an Excel sheet or to a text file.. Any solution for that please?

    Thanks again

  2. #2
    Registered User
    Join Date
    04-05-2012
    Location
    KP
    MS-Off Ver
    Excel 2016
    Posts
    67

    Re: Copy folder names to Excel File

    So i did get a solution myself..

    Go to Command Prompt
    Go to image directory and there type..... Dir > images.txt
    A file named image.txt will be created in that folder with all the folders and files names in it..

  3. #3
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Copy folder names to Excel File

    Another command that you can use at the Command Prompt

    Tree /f>filename.txt

    This will list the folders and their contents under the folder that you are currently navigated to.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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] Want to Pull File Names From Folder into Excel
    By lytsty in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-06-2012, 08:33 PM
  2. Seach in folder and copy data from file based on sheet names in master workbook
    By Hassų in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-06-2012, 09:25 AM
  3. Replies: 15
    Last Post: 08-27-2012, 10:13 AM
  4. [SOLVED] Macro to copy file names and data from each file in a folder into master spreadsheet
    By dee1989 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-10-2012, 05:52 AM
  5. Changing File Names in Excel Folder
    By JPDutch in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 12-02-2011, 11:31 PM

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