On this link
http://support.microsoft.com/default.aspx?scid=kb;en-
us;282257
Microsoft shows how to use Outlook to PRINT a directory
listing (contents of a folder) on a table format.
How can one get the equivalent text file to manipulate the
text entries on the table, for example cut and paste into
another Office Application?
I tried with Outlook to print to a file (it creates a PRN
file) and then open this PRN file with EXCEL to get the
table entries (which is exactly what I want to do!!) but
EXCEL does not properly opens the PRN file created by
OUTLOOK.
I have Office 2000 and Win98. Thanks for your help
A PRN file is generally formatted for a particular printer, so unless
you use a General-Text Only printer driver, you are unlikely to be
able to do anything but print it.
...Alan
--
Alan Edwards, MS MVP W95/98 Systems
http://dts-l.org/index.html
In microsoft.public.win98.apps, "Tio Pepe"
At the command prompt level it's easy, and is the default method. Also doable is a Batch file (BAT
extension)
Copy the following between the CUT lines and paste inside your PLAIN text editor (Notepad will
work), I would suggest naming the file "PrintDir.bat" including the quotes. Save it to
[C:\Windows\Command]. Then opening Explorer I would navigate in the left pane to where you can see
[C:\Windows\SendTo] and right-click the PrintDir.bat and drag it to the SendTo folder. Then all you
have to do is right click any folder and choose PrintDir and the directory contents will be
generated in a file. This file output in sume cases is better than actually printing it cause you
may want to experiment with the layout before you waste alot of paper .
-----------------CUT-----------------
@dir /s /o:e /v %1 >> C:\windows\desktop\Filelist.txt
ECHO -------- >> C:\windows\desktop\Filelist.txt
ECHO -------- >> C:\windows\desktop\Filelist.txt
START "C:\My Programs\EditPadLite\EditPad.exe" C:\windows\desktop\Filelist.txt
-----------------CUT-----------------
Once you start making more batch files, you may want to create their own folder, and if you get
enough DOS programs, and if space permits, you may want to let it have it's own partition. I have
mine at [D:\DOS\Batch]
DIR Command
=======================
=======================
Displays a list of files and subdirectories in a directory.
DIR [drive:][path][filename] [/P] [/W] [/A[[:]attributes]]
[/O[[:]sortorder]] [/S] [/B] [/L] [/V] [/4]
[drive:][path][filename]
Specifies drive, directory, and/or files to list.
(Could be enhanced file specification or multiple filespecs.)
/P Pauses after each screenful of information.
/W Uses wide list format.
/A Displays files with specified attributes.
attributes D Directories R Read-only files
H Hidden files A Files ready for archiving
S System files - Prefix meaning not
/O List by files in sorted order.
sortorder N By name (alphabetic) S By size (smallest first)
E By extension (alphabetic) D By date & time (earliest first)
G Group directories first - Prefix to reverse order
A By Last Access Date (earliest first)
/S Displays files in specified directory and all subdirectories.
/B Uses bare format (no heading information or summary).
/L Uses lowercase.
/V Verbose mode.
/4 Displays year with 4 digits (ignored if /V also given).
Switches may be preset in the DIRCMD environment variable. Override
preset switches by prefixing any switch with - (hyphen)--for example, /-W.
--
Sincerely, | (Š) (Š)
| ------ooo--(_)--ooo------
Andrew H. Carter | /// \\\
d(-_-)b |
"Andrew H. Carter (Applied ROT 17 Left, for Email do 17 Right)" <lfmnb...@knuubxdcq.wnc> wrote in message news:<2g00h0hdeqg7tn56r...@4ax.com>...
Open a DOS prompt and type "dir > filename.txt" (no quotes) redirects the
output to a text file. Use appropriate switches for the dir command to alter
what's saved, e.g. "dir/w" etc.
"Don" <robin...@btinternet.com> wrote in message
news:97d30f2b.04082...@posting.google.com...
>Just caught this thread so ...
>
>Open a DOS prompt and type "dir > filename.txt" (no quotes) redirects the
>output to a text file. Use appropriate switches for the dir command to alter
>what's saved, e.g. "dir/w" etc.
>
NOTE: For any newbies, there needs to be a space in the
above between "DIR" and "/w", else it won't work.
--
Sincerely, | (©) (©)
"Dir/w" (no space) works fine on my 98SE setup, just opened a DOS box and
tried it to confirm. I'll add that I'm fairly sure it's that way "forever",
e.g. since DOS 2.0 at least (1's very foggy in my memory). In fact pretty
sure (but off top of head) that DOS recognizes "/" as a "switch" so space is
not needed for all it's internal commands (and perhaps all it's included
externals but not sure about that). I also seem to recall that there's even
a DOS INT 21 service call to change what the "switch" character is.
Hopefully I won't have to dig out the old 5 1/4's for each and every ver to
confirm :)
"Andrew H. Carter" <lvjg...@knuubxdcq.wnc> wrote in message
news:jbm4j0tt7btgea0hg...@4ax.com...
>Did you check before writing?
>
>"Dir/w" (no space) works fine on my 98SE setup, just opened a DOS box and
>tried it to confirm. I'll add that I'm fairly sure it's that way "forever",
>e.g. since DOS 2.0 at least (1's very foggy in my memory). In fact pretty
>sure (but off top of head) that DOS recognizes "/" as a "switch" so space is
>not needed for all it's internal commands (and perhaps all it's included
>externals but not sure about that). I also seem to recall that there's even
>a DOS INT 21 service call to change what the "switch" character is.
>Hopefully I won't have to dig out the old 5 1/4's for each and every ver to
>confirm :)
>
Well, slap me and call me Sally. Though that is probably
only one of a couple where such are allowed, and only if the
format is of:
Command /Switch Term
Learn something new everyday!