Discussion:
print out list of files in folder
(too old to reply)
Carrie Garth (MVP)
2003-09-18 13:43:37 UTC
Permalink
Hi Jerry,

There is not a built-in way to print a list of files in Explorer. However, since you
have 1,000+ files (word doc files)" then perhaps you have Microsoft Office and have
Outlook's Advanced Find component installed. If yes, then you can use it to "Print a
view of a file list". For more information search Outlook's Help for words in
double-quotes.

BTW, if you would like to save the file listing in an Excel file (for further
manipulation, etc.) you can copy the result set into Excel in the following way
(these steps are specific for Office 2000, but I think they work for other versions,
too.)

For a file list of a folder generate a view by following these steps: Open Outlook.
On the Outlook Bar, click Other or Other Shortcuts. Click My Computer and
double-click the drive that contains the file list you want to save.

For a file search generate a view by following these steps: Clicking Start > Search
Using Microsoft Outlook... Search for the files (choose applicable options from
the various drop-down boxes, buttons, tabs, etc., such as the "Browse" to select
multiple folders and to Search subfolders.)

After the view is generated, if desired, View > Current View > Customize Current
View. Choices include choosing what fields to display, ordering of fields, grouping,
sorting, fonts, grid lines, shading, etc.

To print directly click the File menu, click Print, and in the Print style box, click
Table Style.

To save the table list of results:

- Click within the table list of results
- Choose [Menu bar] "Edit > Select All" (or keyboard CTRL+A)
- Use the keyboard command CTRL+C to copy the directory listing
- Paste into Excel.
Note: To paste into Word, choose Edit > Paste Special > Unformatted Text

P.S. In regards to the command posted by Steve, you will need to add the /s switch
to list the files in directory and all subdirectories.
--
Carrie Garth, Microsoft MVP for Windows 2000
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- c x g

: "jerry" <mami233 AT hotmail DOT com>
: Wrote in message news:0af201c37c83$60838d60$***@phx.gbl
: Sent: Tuesday, September 16, 2003 1:50 PM
:
: I have 1,000+ files (word doc files) that are in a folder
: and sub-folders.
:
: Q: I can view the files, details, etc., on the computer,
: but how do I print out the listings, and the detail?
:
: Any thoughts? Thank you.
Lars
2003-09-19 10:45:41 UTC
Permalink
There is no need for that long detour!

Open a cmd prompt and do a dir command, redirecting its
output straight to an Excel file. Excel will create an
"early version" Excel file when triggered this way.

Later on when you open the file Excel will prompt you for a
few things on how to format the resulting sheet.

Example;
C:\
Dir >Exceltest.xls

On Thu, 18 Sep 2003 08:43:37 -0500, "Carrie Garth \(MVP\)"
Post by Carrie Garth (MVP)
Hi Jerry,
There is not a built-in way to print a list of files in Explorer. However, since you
have 1,000+ files (word doc files)" then perhaps you have Microsoft Office and have
Outlook's Advanced Find component installed. If yes, then you can use it to "Print a
view of a file list". For more information search Outlook's Help for words in
double-quotes.
BTW, if you would like to save the file listing in an Excel file (for further
manipulation, etc.) you can copy the result set into Excel in the following way
(these steps are specific for Office 2000, but I think they work for other versions,
too.)
For a file list of a folder generate a view by following these steps: Open Outlook.
On the Outlook Bar, click Other or Other Shortcuts. Click My Computer and
double-click the drive that contains the file list you want to save.
For a file search generate a view by following these steps: Clicking Start > Search
Using Microsoft Outlook... Search for the files (choose applicable options from
the various drop-down boxes, buttons, tabs, etc., such as the "Browse" to select
multiple folders and to Search subfolders.)
After the view is generated, if desired, View > Current View > Customize Current
View. Choices include choosing what fields to display, ordering of fields, grouping,
sorting, fonts, grid lines, shading, etc.
To print directly click the File menu, click Print, and in the Print style box, click
Table Style.
- Click within the table list of results
- Choose [Menu bar] "Edit > Select All" (or keyboard CTRL+A)
- Use the keyboard command CTRL+C to copy the directory listing
- Paste into Excel.
Note: To paste into Word, choose Edit > Paste Special > Unformatted Text
P.S. In regards to the command posted by Steve, you will need to add the /s switch
to list the files in directory and all subdirectories.
Lars
Stockholm

Loading...