Copying Files in a Directory to Excel/Word, etc.


Go Back   Computer Help Articles > Windows XP Basics
User Name
Password
FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 01-05-2006, 02:01 AM
Sharon_of_WV
 
Posts: n/a
Default Copying Files in a Directory to Excel/Word, etc.

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
  #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
  #3  
Old 01-05-2006, 02:01 AM
Sharon_of_WV
 
Posts: n/a
Default Re: Copying Files in a Directory to Excel/Word, etc.

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

>
>
>

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Forum Jump

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


All times are GMT. The time now is 05:30 AM.


Powered by vBulletin Version 3.5.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd. SEO by vBSEO 2.3.2 © 2005, Crawlability, Inc.

Copying Files in a Directory to Excel/Word, etc.