×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

directory printer

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,

RE: directory printer

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

RE: directory printer

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

RE: directory printer

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.

RE: directory printer

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

RE: directory printer

I suppose that the proper command line is
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

harumph!

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

RE: directory printer

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.

RE: directory printer

(OP)
thanks for all
your notes were very helpful
thanks

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources