Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

directory printer

Status
Not open for further replies.

WaterGIS

Geotechnical
Joined
Jun 19, 2002
Messages
37
Location
JO
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,
 
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
 
thanks alot
but what i was lookg for is printing the files properties in the folder
best
 
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.
 
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.
 
harumph!

"DOS>" was meant to be the DOS prompt, nyaah.
 
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.
 
thanks for all
your notes were very helpful
thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top