|
#1
|
|||
|
|||
|
Hi,
I am in need of copying filenames from a directory into an Excel Spreadsheet. To give an example of what application I have for this need: I have ~1000 files that I need to sort & then index various different ways (will add tracking #, Associated Name, comments, etc). I figured out how to do a filelist (in DOS). However, that also shows all the file attributes (such as creation date, file size, etc) which I don't need. I only need the filenames. Can you offer assistance, please? Thanks for your help in advance ![]() |
|
#2
|
|||
|
|||
|
Hi Sharon_of_WV,
Use the DIR command with the /b switch. -- Best of Luck, Rick Rogers, aka "Nutcase" - Microsoft MVP http://mvp.support.microsoft.com/ Associate Expert - WindowsXP Expert Zone www.microsoft.com/windowsxp/expertzone Windows help - www.rickrogers.org "Sharon_of_WV" <Sharon_of_WV@discussions.microsoft.com> wrote in message news:B5C9C373-3312-4D4C-9871-B985FF5A46B6@microsoft.com... > Hi, > I am in need of copying filenames from a directory into an Excel > Spreadsheet. To give an example of what application I have for this need: > I > have ~1000 files that I need to sort & then index various different ways > (will add tracking #, Associated Name, comments, etc). I figured out how > to > do a filelist (in DOS). However, that also shows all the file attributes > (such as creation date, file size, etc) which I don't need. I only need > the > filenames. > > Can you offer assistance, please? Thanks for your help in advance ![]() |
|
#3
|
|||
|
|||
|
Thanks so much for the quick response! It works perfectly for what I need.
Sharon ![]() "Rick "Nutcase" Rogers" wrote: > Hi Sharon_of_WV, > > Use the DIR command with the /b switch. > > -- > Best of Luck, > > Rick Rogers, aka "Nutcase" - Microsoft MVP > http://mvp.support.microsoft.com/ > Associate Expert - WindowsXP Expert Zone > www.microsoft.com/windowsxp/expertzone > Windows help - www.rickrogers.org > > "Sharon_of_WV" <Sharon_of_WV@discussions.microsoft.com> wrote in message > news:B5C9C373-3312-4D4C-9871-B985FF5A46B6@microsoft.com... > > Hi, > > I am in need of copying filenames from a directory into an Excel > > Spreadsheet. To give an example of what application I have for this need: > > I > > have ~1000 files that I need to sort & then index various different ways > > (will add tracking #, Associated Name, comments, etc). I figured out how > > to > > do a filelist (in DOS). However, that also shows all the file attributes > > (such as creation date, file size, etc) which I don't need. I only need > > the > > filenames. > > > > Can you offer assistance, please? Thanks for your help in advance ![]() > > > |
![]() |
| Thread Tools | Search this Thread |
| Display Modes | |
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Missing files in Temporary Internet Files Directory | MHR | Internet Explorer 6 | 1 | 01-05-2006 04:33 PM |
| Re: cd burning software | MIMITEX1 | Windows XP Photos | 1 | 01-05-2006 07:11 AM |
| Keeping backup of my pictures in my order | Gladys222 | Windows XP Photos | 10 | 01-05-2006 07:08 AM |
| Missing files in Temporary Internet Files Directory | MHR | Windows XP New Users | 1 | 01-05-2006 03:58 AM |
| Missing files in Temporary Internet Files Directory | MHR | Windows XP Help and Support | 1 | 01-05-2006 02:40 AM |