📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

filename not file copying in bulk

hi all

I wonder if anyone can help me??

I have a lot of files that I need to index. I need to copy the filename into excel. To do this at the moment I have to right click on the file, rename then copy then paste into excel. I have a lot of files and doing it this way would take me ages!! :-(

Does anyone know if there is a quicker way to do this or a program (free??) which will do it for me?

Thanks in advance!

Comments

  • albertross_2
    albertross_2 Posts: 8,932 Forumite
    start, run, cmd

    c:
    cd \whateverthedirectoryiscalled

    dir >c:\files.txt

    then import the text file to excel.
    Ever get the feeling you are wasting your time? :rolleyes:
  • espresso
    espresso Posts: 16,448
    Part of the Furniture 10,000 Posts Combo Breaker
    Forumite
    Download ASAP Utilities which is a plug-in for Excel from here and then do Ctrl+Alt+f
    :doh: Blue text on this forum usually signifies hyperlinks, so click on them!..:wall:
This discussion has been closed.
★ ★ ★ Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 355.9K Banking & Borrowing
  • 255K Reduce Debt & Boost Income
  • 456.2K Spending & Discounts
  • 248.4K Work, Benefits & Business
  • 606.1K Mortgages, Homes & Bills
  • 179.1K Life & Family
  • 263.9K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.2K Discuss & Feedback
  • 37.7K Read-Only Boards
Quick Search

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.