directory printer
directory printer
(OP)
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,
Best regards,
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
|
RE: directory printer
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
RE: directory printer
but what i was lookg for is printing the files properties in the folder
best
RE: directory printer
http:
RE: directory printer
http://www.asap-utilities.com/
RE: directory printer
DOS> DIR E >FILE.TXT
Then, open it in Excel... That's one way of doing it.
RE: directory printer
Don Phillips
http://worthingtonengineering.com
RE: directory printer
DIR > FILE.TXT (without the E)
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: directory printer
"DOS>" was meant to be the DOS prompt, nyaah.
RE: directory printer
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: directory printer
your notes were very helpful
thanks