View Single Post
  #2  
Old 01-05-2006, 02:01 AM
Rick \Nutcase\ Rogers
 
Posts: n/a
Default Re: Copying Files in a Directory to Excel/Word, etc.

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



Reply With Quote