Results 1 to 3 of 3
  1. #1
    redbull's Avatar
    redbull is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Mar 2012
    Location
    Missouri
    Posts
    480

    Find every txt file on a drive, across all folders and sub folders. Then bring into excel.


    I have a system change coming up, and I don't know how large of an impact it will have.


    I am able to search using windows for every .txt file on a shared drive... and it will search the subfolders all the way down. But I'm trying to bring that information back into excel, and windows... well it doesn't cut the mustard.

    Does anyone have a tool that runs in vba where I can put in the parent directory I want, then have it search for all files with the .txt file format, then put that information in excel? I know its a big ask, but I can't be the only one that's had to come up with a solution for this.

  2. #2
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    yeah


    DIR C:\*.* /s >> TotalContents.txt

    Then import That file to excel.

  3. #3
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    One small correction to that suggestion. It should be:

    DIR C:\*.txt /s >> TotalContents.txt

    because you only want the .txt files.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. List Folders
    By LonghronJ in forum Modules
    Replies: 4
    Last Post: 02-15-2016, 08:37 AM
  2. Replies: 20
    Last Post: 03-13-2014, 12:50 PM
  3. Search for associated folders in file dialog box
    By john_billau in forum Programming
    Replies: 1
    Last Post: 01-27-2012, 03:48 PM
  4. Deleting Folders
    By Madmax in forum Access
    Replies: 1
    Last Post: 10-05-2011, 11:02 AM
  5. Import from various folders
    By Statique in forum Import/Export Data
    Replies: 2
    Last Post: 07-02-2009, 06:10 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums