Copy multiple file names, as text (table of contents) into a word

A

Arthur the Author

I want to create a Table of Contents listing for a training document.

"Selecting ALL" in a directory will highlight all the file names that I want
to paste in a word table or excell document.

I just need the text of the document names and extensions .... How can I
just "paste" the text without imbedding the file?
 
M

Myrna Larson

You would need VBA code to do this. If you aren't familiar with it, it will be
quicker to do it by hand.

Another option is to go to a DOS prompt, then issue the DIR command,
redirecting the output to a text file, like this

DIR *.* >MyFileList.txt


On Tue, 19 Oct 2004 13:47:06 -0700, "Arthur the Author" <Arthur the
 
G

Gord Dibben

Arthur

Several methods to accomplish this.......I like Tushar's best.

To add a "Print Directory" feature to Explorer, go to
this KB Article.

http://support.microsoft.com/default.aspx?scid=KB;EN-US;q272623&

Or you can download Printfolder 1.2 from.....

http://no-nonsense-software.com/freeware/

I use PF 1.2 and find it to be more than adequate with custom features.

OR Go to DOS(Command) prompt and directory.
Type DIR >MYFILES.TXT

All the above create a *.TXT file which can be opened in Excel.

One more method if you want to by-pass the *.TXT file and pull directly to
Excel is to use Tushar Mehta's Excel Add-in. This allows filtering and
sorting once you have the data in Excel.

http://www.tushar-mehta.com/ scroll down to Add-ins>Directory Listing.

Download the ZIP file and un-zip to your Office\Library folder.

Gord Dibben Excel MVP


On Tue, 19 Oct 2004 13:47:06 -0700, "Arthur the Author" <Arthur the
 
Top