I have a folder with thousands of pdfs in it - and I want to copy the names of all the pdfs and compile them in an Excel spreadsheet. All I know is how to get to DOS, that's it. Help please! Put the list into a text file and OPEN that in Excel

Just the filename
Dir /b *.pdf > pdflist.txt

With the path too
Dir /b /s *.pdf > pdflist.txt

I really am a dunce with this. The folder with the pdfs in it is on my Z drive - through several other folders. How do I get to the folder that has all the pdfs in it?USE the CD command:
Code: [Select]cd Z:\path to pdfsdir /s *.pdf will FIND all pdf files and their location:

C:\>dir /s *.pdf
Volume in drive C is OS

Directory of C:\DELL\Docs\manual

09/10/2007 04:44 PM 13,980,991 eom.pdf
1 File(s) 13,980,991 bytes


cd C:\Documents and Settings\Bill Richardson\My Documents\

dir *.pdf

Directory of C:\Documents and Settings\Bill Richardson\My Documents\PDF

09/03/2005 01:51 PM 17,834 20-5655.pdf
05/04/2005 08:53 PM 48,706 DSCF828warranty.pdf
03/30/2005 10:51 AM 3,175,838 DSCP100.pdf
04/09/2006 06:52 PM 176,956 Health1.pdf
04/09/2006 06:53 PM 176,956 health2.pdf
03/13/2006 07:19 PM 713,400 moneyback.pdf
10/15/2005 12:44 AM 21,587 timeF.pdf
7 File(s) 4,331,277 bytes


Directory of C:\Program Files\Adobe\Reader 9.0\Reader\IDTemplates\ENU

08/16/2006 02:09 PM 82,070 AdobeID.pdf
08/16/2006 02:08 PM 80,651 DefaultID.pdf
2 File(s) 162,721 bytes

Directory of C:\Program Files\Adobe\Reader 9.0\Reader\plug_ins\Annotations\Stam
ps

06/20/2005 05:36 PM 112,498 Words.pdf
1 File(s) 112,498 bytes



Directory of C:\Program Files\ArcSoft\PhotoStudio 5.5

10/10/2006 12:20 AM 6,629,353 PhotoStudio 5.5 QSG.pdf
1 File(s) 6,629,353 bytes

Directory of C:\Program Files\Corel\WordPerfect Office 2000\shared\REFCNTR

03/25/1999 07:39 AM 45,119 Admn9en.pdf
03/26/1999 08:13 AM 702,443 CC9en.PDF
03/27/1999 03:46 AM 2,957,541 co9guide.PDF
03/26/1999 10:30 PM 2,308,560 pr9en.PDF
03/27/1999 01:23 AM 4,960,752 qp9en.PDF
04/20/1999 10:37 PM 1,273,516 trellix2.pdf
03/27/1999 10:32 PM 4,436,042 wp9en.PDF
03/29/1999 01:15 AM 705,713 xml9en.PDF
8 File(s) 17,389,686 bytes

Directory of C:\READIRIS

09/24/1998 03:24 PM 2,068,680 readiris.pdf
1 File(s) 2,068,680 bytes

Total Files Listed:
40 File(s) 59,997,199 bytes
0 Dir(s) 307,429,879,808 bytes free

C:\>Almost forgot:
Code: [Select]cd /d "Z:\path to pdfs"
If the bat is on a different Drive.