H
Harry
Is it possible to export/convert the contents of a folder from Explorer to a
text file or to an Excel format?
text file or to an Excel format?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Kaylene aka Taurarian
Do you mean print the contents of a folder as a list of files?
Has the option to save as a text file
http://www.karenware.com/powertools/ptdirprn.asp
Directory Printer v3.4
Has the option to save as a text file
http://www.karenware.com/powertools/ptdirprn.asp
Directory Printer v3.4
H
Harry
No, I want to import a list of files within a folder to Excel or something
similar.
similar.
K
Kaylene aka Taurarian
Once you have saved the list as a text file (using Karen's print directory), you
can open the same in Word, edit out what you dont want and then paste the same
into excel
If you don't want to use the program then
1) Click START, then click RUN
2) Type in CMD and select OK.
The Windows Command Prompt appears.
3) Access the directory where your files are.
For example: If the files are located in Documents and Settings\User Name\My
Documents\My Music, then you would type CD "C:\documents and settings\user
name\my documents\my music" and press the enter key. NB: include the quotation
marks.
If you are unsure of the correct path right click one of the files in the
directory that you wish to make a list of and select properties from the menu
popup and then look for the field Location, this will give you the path.
4) Once you have accessed the directory (step 3) then type : DIR> myfiles.txt
then press enter. This will create a text file myfiles.txt.
5) In Explorer, browse to the folder, locate the myfiles.txt file.
Note this file can be edited in Notepad or any other Word processing program you
have.
can open the same in Word, edit out what you dont want and then paste the same
into excel
If you don't want to use the program then
1) Click START, then click RUN
2) Type in CMD and select OK.
The Windows Command Prompt appears.
3) Access the directory where your files are.
For example: If the files are located in Documents and Settings\User Name\My
Documents\My Music, then you would type CD "C:\documents and settings\user
name\my documents\my music" and press the enter key. NB: include the quotation
marks.
If you are unsure of the correct path right click one of the files in the
directory that you wish to make a list of and select properties from the menu
popup and then look for the field Location, this will give you the path.
4) Once you have accessed the directory (step 3) then type : DIR> myfiles.txt
then press enter. This will create a text file myfiles.txt.
5) In Explorer, browse to the folder, locate the myfiles.txt file.
Note this file can be edited in Notepad or any other Word processing program you
have.
D
David Candy
Place one or both of these files in the Sendto menu (type sendto in Start Run) or on the desktop. Then send a folder (or drag and drop a folder on the icon) and a text file called Folder Property List.txt (a tab delimited file) will appear on the desktop. The file has 51 columns, most are blank for most files, delete the one you don't want. Excel will import seamlessly.
One overwrites the previous list and one adds to it.
One overwrites the previous list and one adds to it.
B
Bruce Chambers
Greetings --
From the command prompt (Start > Run > Cmd.exe), simply change to
the desired directory and type "dir > filelist.txt" or "dir > lpt1,"
just as you used to do in DOS. Any of the switches for the DIR
command (type "dir /?") will work with this command, if you wish to
modify the output. You can then subsequently edit the resulting text
file using NotePad, WordPad, Word, etc.
Alternatively:
HOW TO Add a Print Directory Feature for Folders in Windows XP
http://support.microsoft.com/?kbid=321379
Bruce Chambers
--
Help us help you:
You can have peace. Or you can have freedom. Don't ever count on
having both at once. - RAH
From the command prompt (Start > Run > Cmd.exe), simply change to
the desired directory and type "dir > filelist.txt" or "dir > lpt1,"
just as you used to do in DOS. Any of the switches for the DIR
command (type "dir /?") will work with this command, if you wish to
modify the output. You can then subsequently edit the resulting text
file using NotePad, WordPad, Word, etc.
Alternatively:
HOW TO Add a Print Directory Feature for Folders in Windows XP
http://support.microsoft.com/?kbid=321379
Bruce Chambers
--
Help us help you:
You can have peace. Or you can have freedom. Don't ever count on
having both at once. - RAH
H
Harry
Thankyou all, that works fine.
Now I have a problem getting Excel to import the data correctly but that's
for another day, another newsgroup.
Thanks again.
Now I have a problem getting Excel to import the data correctly but that's
for another day, another newsgroup.
Thanks again.