Piano Forum

Topic: Copying file names to Word or Excel  (Read 2343 times)

Offline mr music

  • PS Silver Member
  • Full Member
  • ***
  • Posts: 152
Copying file names to Word or Excel
on: May 20, 2009, 01:11:46 PM
I want to copy and paste all ‘My Document’ file names (not the file just the name of each one) from Windows xp to Excel or at least Word. Any ideas on how to do this, apart from copying and pasting each one or typing them out individually ?

Mr Music.
MUSIC, MY LIFE.

Offline thalbergmad

  • PS Silver Member
  • Sr. Member
  • ***
  • Posts: 16741
Re: Copying file names to Word or Excel
Reply #1 on: May 20, 2009, 02:10:54 PM
For your sake i hope there is.

For my sake I hope there is not, as i have just spent 3 weeks making a spreadsheet of me concertos.

Thal
Curator/Director
Concerto Preservation Society

Offline morningstar

  • PS Silver Member
  • Sr. Member
  • ***
  • Posts: 1465
Re: Copying file names to Word or Excel
Reply #2 on: May 20, 2009, 04:15:39 PM
So you want the name of the file and none of the contents transferred to a spreadsheet? Interesting...ima go experiment.

Offline Bob

  • PS Silver Member
  • Sr. Member
  • ***
  • Posts: 16368
Re: Copying file names to Word or Excel
Reply #3 on: May 20, 2009, 05:15:55 PM
DirPrinting by MajuSoft

It's a freebie or was when I got it.  I don't know if it will do a spreadsheet, but it will copying filenames to a temp file or your clipboard.  Very useful.

I don't know where I got it exactly.  You'll have to hunt for it but I imagine it's out there somewhere.
Favorite new teacher quote -- "You found the only possible wrong answer."

Offline morningstar

  • PS Silver Member
  • Sr. Member
  • ***
  • Posts: 1465
Re: Copying file names to Word or Excel
Reply #4 on: May 21, 2009, 01:49:42 AM
majusoft.de/DirPrinting/index_en.htm
Is that the program?

Offline Bob

  • PS Silver Member
  • Sr. Member
  • ***
  • Posts: 16368
Re: Copying file names to Word or Excel
Reply #5 on: May 21, 2009, 02:23:00 AM
Yep.  That's it.  I started it up today to see if it was what I was thinking.  I don't know what version I have but it worked for my purposes.  I noticed the help files aren't present though today.  And I see it does do Excel files on that link posted above.  Nifty little program.  If you have pdf music files with the file name being the title of the piece, you can have that program stick all those file name/titles into a word document.  It will even copy filenames off subdirectories too.  And it's free.  I don't use it much but it's one of those free niche programs that is very useful in certain situations.
Favorite new teacher quote -- "You found the only possible wrong answer."

Offline Bob

  • PS Silver Member
  • Sr. Member
  • ***
  • Posts: 16368
Re: Copying file names to Word or Excel
Reply #6 on: May 21, 2009, 02:28:20 AM
I see MajuSoft is German.  Why am I not surprised?  (Bob is impressed with many German things.)

I'm not too impressed with their site and it looks like they only have two or three programs, but the directory printing one is good.  The others probably are too.  If I ever need to convert Euros, I'm all set.
Favorite new teacher quote -- "You found the only possible wrong answer."

Offline morningstar

  • PS Silver Member
  • Sr. Member
  • ***
  • Posts: 1465
Re: Copying file names to Word or Excel
Reply #7 on: May 21, 2009, 01:50:26 PM
Germans make many good things :)
It looks interesting, have been testing it out also. Hope this is good for mr music!
For more information about this topic, click search below!
 

Logo light pianostreet.com - the website for classical pianists, piano teachers, students and piano music enthusiasts.

Subscribe for unlimited access

Sign up

Follow us

Piano Street Digicert