Solved

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

Posted on 2004-08-20
6
368 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 400 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 100 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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Hi, I've made you some graphics for a better understanding how RAID works. First of all, there are two ways a raid can be generated: - By hardware - By software What does that mean? This means: If you have a hardware RAID controller, there…
Create your own, high-performance VM backup appliance by installing NAKIVO Backup & Replication directly onto a Synology NAS!
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 tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…

759 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now