directory printer

[WaterGIS]

I’m looking for excel sheet that work as directory printer, to print the all the file name, type and other properties in an excel sheet
Best regards,

 

[yogia]

Hi WaterGIS:

If you are using EXCEL, the following macro will print the names of all the sheets in your workbook (starting from cell A1 down) ...

----------------------------------------------
Sub y_1()
'Macro 1/28/2007 by Yogi Anand
For i = 1 To ThisWorkbook.Sheets.Count
Cells(i, 1) = Sheets(i).Name
Next i
End Sub
----------------------------------------------

I realize that you want to print more than just the names of the sheets in a workbook, but this should get you started.

Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC
ANAND Enterprises LLC

http://www.energyefficientbuild.com

 

[WaterGIS]

thanks alot
but what i was lookg for is printing the files properties in the folder
best

 

[handleman]

Do you have any abilities/experience with VB or VBA? If you do, this link should help you:

http://msdn2.microsoft.com/en-us/library/aa201321(office.11).aspx

 

[Clyde38]

Get ASAP utilities.... It's free and has this feature.

http://www.asap-utilities.com/

 

[DaveVikingPE]

You can always "dump" a directory echo into a text file from the DOS prompt:

DOS> DIR E >FILE.TXT

Then, open it in Excel... That's one way of doing it.

 

[DonPhillips]

An old DOSman. Was gonna be my suggestion as well. Used to use that a lot back in the day - especially when you have to work with the output in a script or something.

Don Phillips

http://worthingtonengineering.com

 

[joerd]

I suppose that the proper command line is
[tt]DIR > FILE.TXT[/TT] (without the E)

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

 

[DaveVikingPE]

harumph!

"DOS>" was meant to be the DOS prompt, nyaah.

 

[joerd]

Sorry to have offended you, I was referring to the E after the DIR statement.

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

 

[WaterGIS]

thanks for all
your notes were very helpful
thanks