Document Properties - printing

  • Thread starter Thread starter Sandi
  • Start date Start date
S

Sandi

Any idea of how I can get the document properties of an
Excel worksheet to print?
 
You can place the properties you want on a empty sheet and print it
Run this macro on a empty sheet
Sub test()
rw = 1
Worksheets(1).Activate
For Each p In ActiveWorkbook.BuiltinDocumentProperties
On Error Resume Next
Cells(rw, 1).Value = p.Name
Cells(rw, 2).Value = p.Value
rw = rw + 1
On Error GoTo 0
Next
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top