We’d like to remind Forumites to please avoid political debate on the Forum.

This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

📨 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!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide
Want to become a Forum Ambassador? Visit the Community Noticeboard for details on how to apply

filename not file copying in bulk

beeb_boy
beeb_boy Posts: 43 Forumite
in Techie Stuff
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 Forumite
    Part of the Furniture 10,000 Posts Combo Breaker
    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
  • 353.9K Banking & Borrowing
  • 254.3K Reduce Debt & Boost Income
  • 455.2K Spending & Discounts
  • 246.9K Work, Benefits & Business
  • 603.5K Mortgages, Homes & Bills
  • 178.3K Life & Family
  • 261K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 37.7K Read-Only Boards

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.
Update Your Picture