Macro to Print All Documents in a Directory (107687)

MORE INFORMATION

WARNING: ANY USE BY YOU OF THE CODE PROVIDED IN THIS ARTICLE IS AT YOUR OWN RISK. Microsoft provides this macro code "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

Sub MAIN

doc$ = Files$("*.DOC")
While doc$ <> ""
 FilePrint .FileName = doc$
 doc$ = Files$()
Wend

End Sub
				

The above macro uses the Files$() function and FilePrint statement to print the documents with a .DOC file extension in the current folder.

You can customize the above macro to print files from a specified folder by adding a ChDir statement at the top of the macro.

   ChDir "C:\WinWord"   'changes the current folder to C:\WINWORD
				

Note: By specifying "*.DOC" on the first iteration and omitting it thereafter, you can use the Files$() function to generate a list of files. If no files match, an empty string ("") is returned.

This same idea can be used to create a list of file names in the current folder. The following example macro creates a new document with the file names from the current folder.

Sub MAIN

FileNewDefault
doc$ = Files$("*.*")
While doc$ <> ""
 Insert doc$
 InsertPara
 doc$ = Files$()
Wend

End Sub
				

Kbcategory: kbusage kbmacro