Printing a list of files 1

[pcullen]

Hi,
I wish to print a list of contents of a folder
e.g A printout of the names of all the files in MyDocuments

Thanks

 

[xlhelp]

Need to know what OS you are running

 

[pcullen]

Running Windows 2000

 

[xlhelp]

Start Notepad. Copy and paste the following:

@echo off
dir %1 /-p /o:gn > "%temp%\Listing"
start /w notepad /p "%temp%\Listing"
del "%temp%\Listing"
exit

Save the file as [color#880000]Print.bat[/color] in the Windows directory (or WINNT).

Under Windows Explorer, go to Tools, Folder Options, File Types tab, and choose File Folder. (you have to scroll down to N/A)
Click Advanced, and then New.

In the Action box, type Directory Listing.
In the Application used to perform action box, type Print.bat, click OK. Click OK, OK, Close.

In Windows Explorer, right-click the folder that you would like to print a directory listing of, and then click Directory Listing.

 

[pcullen]

Many Thanks

 

[mbarron]

Check out this thread(thread615-206821)

It shows how to get the same results as the print out using xlhelp's (star deserving) post but as a text file.

or change the second line of code to:
start /w notepad "%temp%\Listing"
to see the listing in notepad. Mike

 

[pcullen]

Have it done

Thanks Again