[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

List of file names in a folder in .txt or xls file

Posted on 2004-08-20
6
Medium Priority
?
383 Views
Last Modified: 2010-04-03
At work we have about 2,000 files of .rpt files ( report files ) in a folder on a server.  I want to be able to place those 2,000 filenames in a format that I can put in Excel and run lookup tables on.  Can this be done.??

Thanks
0
Comment
Question by:awehme
  • 3
  • 2
6 Comments
 
LVL 12

Accepted Solution

by:
Gary Dewrell earned 1600 total points
ID: 11857382
Hi awehme,
I can tell you a low tech way that works.

from a dos prompt in the directory issue this command:  dir /B > files.txt
then load Excel and open files.txt  It will import the file names into excel.


God Bless
0
 
LVL 9

Assisted Solution

by:tosh9iii
tosh9iii earned 400 total points
ID: 11857384
Could you elaborate a little on the "lookup tables"?

But for now see if this does any good:
http://camalotdesigns.com/software/xfl/
0
 
LVL 12

Expert Comment

by:Gary Dewrell
ID: 11857393
What I gave you simply gets the names into excel. Once you have them into excel you can do what ever other functions you want to do.  Here is a step by step article on how to use lookup tables.

http://www.glencoe.com/ps/computered/pas/article.php4?articleId=411
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
LVL 2

Author Comment

by:awehme
ID: 11857398
Thanks guys.

gdewrell is what i was looking for

Tosh9iii....cool I didn't know that was out there
0
 
LVL 2

Author Comment

by:awehme
ID: 11857587
Is there also a way to get the attrib's to the files.  ie. Date, time, size ??
0
 
LVL 2

Author Comment

by:awehme
ID: 11857612
found it.  It's Just Dir > files.txt
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Check out the easy way to Export Thunderbird to MS Outlook. It can be done effectively by using manual method and if you are not much into coding then you can definitely try the third party tool for the conversion.
The following article sheds light on easy-to-use steps to recover non-responding hard drives without data loss. Count on these approaches to fix undetectable, not responding, or non-working hard drives.
This video teaches viewers how to encrypt an external drive that requires a password to read and edit the drive. All tasks are done in Disk Utility. Plug in the external drive you wish to encrypt: Make sure all previous data on the drive has been …
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…
Suggested Courses
Course of the Month7 days, 20 hours left to enroll

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question