Question

  • Creator
    Topic
  • #2144403

    File/Folder listing in Excel

    by snak ·

    I need to scan a network drive which has over 9,000 Access Databases on it and put the results (folder/file name, date modified, last user, size etc) into an excel file. The DIR > file.txt is useless as it would take me a lifetime to manually edit it. Kutools just crashes Excel. It isn’t possible to filter databases in a Windows Folder, select all and drag to excel because for some batshit reason, when you try to do that Excel tries to open the files, rather than just record the filename (I didn’t think this would work but someone suggested it). Does anyone have a solution that works?

You are posting a reply to: File/Folder listing in Excel

The posting of advertisements, profanity, or personal attacks is prohibited. Please refer to our Community FAQs for details. All submitted content is subject to our Terms of Use.

All Answers

Share your knowledge