Link to home
Start Free TrialLog in
Avatar of awehme
awehmeFlag for United States of America

asked on

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

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
ASKER CERTIFIED SOLUTION
Avatar of Gary Dewrell
Gary Dewrell
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
Avatar of awehme

ASKER

Thanks guys.

gdewrell is what i was looking for

Tosh9iii....cool I didn't know that was out there
Avatar of awehme

ASKER

Is there also a way to get the attrib's to the files.  ie. Date, time, size ??
Avatar of awehme

ASKER

found it.  It's Just Dir > files.txt