Printing File Contents to an Excel Spreadsheet

[Existant]

I did a small search here and on the internet thats yielded a couple results.

I was just wondering if anyone knows a sure fire way that I can list the contents of my music folder (K:\Music) on an excel spreadsheet?

Please and thanks

[teylyn]

In the command window (DOS), you can do a

dir > mymusic.txt

then open the mymusic.txt with Excel

[Existant]

I'm running windows 7, whenever I do the dir > mymusic.txt I get access denied.

in the cmd prompt, I can get it to go to C, but it won't let me ** K:\Music to my music directory

[teylyn]

Have you tried a search? There are lots of hits for a google

excel macro to list files in a folder

[Existant]

I tried numerous google search results.

This seems to be the closest I got only because it actually listed the headings, but no files before I get an error

Please Login or Register  to view this content.

Do I change every C:\ to K:\Music?

[Existant]

I tried numerous google search results.

This seems to be the closest I got only because it actually listed the headings, but no files before I get an error

Please Login or Register  to view this content.

Do I change every C:\ to K:\Music?