Copy a directory listing

C

Carol

Is it possible to highlight and copy my individual Outlook
directory listings into a spreadsheet using either Excel
or Access?

Whenever I try to highlight and copy my directories using
Alt, prt Scrn, it of course copies the title bars also. I
would like to make a spreadsheet showing just the file
names of each directory. Can this be done.

Thank you.
 
M

Mike Williams [MVP]

Carol said:
Is it possible to highlight and copy my individual Outlook
directory listings into a spreadsheet using either Excel
or Access?

Whenever I try to highlight and copy my directories using
Alt, prt Scrn, it of course copies the title bars also. I
would like to make a spreadsheet showing just the file
names of each directory. Can this be done.
Click to expand...

Open a DOS/CMD prompt at the desired folder and type

dir /s > files.txt

That will output the folder (and subfolder) listing to a text file that you
can munge in Excel or Access. You could also write some VBA code to traverse
the folders getting the same information.
--

Mike Williams - Office MVP
http://www.mvps.org/

Please respond in the same thread on this newsgroup. Make sure you
include details of your application and Windows versions, plus any
service pack updates.

Do not mail to me directly without invitation - you have a choice of
getting ignored or billed for my time. Most questions can be answered
by reading recent NG posts, checking the MVPS web FAQs or searching the
relevant Google archive e.g.
http://groups.google.com/groups?group=microsoft.public.word.spelling.grammar
 
Top