is it possible to print file properties in excel?
 

Can the file properties in Excel be printed? How?

Hi Chrysalla,

Sub Tester()
Dim dProp As DocumentProperty
Dim WB As Workbook
Dim i As Long

Set WB = ActiveWorkbook

For Each dProp In WB.BuiltinDocumentProperties
On Error Resume Next
Debug.Print dProp.Name, dProp.Value
On Error GoTo 0
Next dProp

End Sub


---
Regards,
Norman



"Chrystalla" wrote in message
...
Can the file properties in Excel be printed? How?