How to print Excel Metadata in Excel 2010

[smhish]

I can find multiple post on how to hide it, even how to display it on screen.
I have found some VBA showing how to print a list of the properties and VBA to print propteries to the Immediate window. All of these are "almost" what I need.
I need to be able to "print the properites" to a new worksheet within the Excel file. Or print it to a txt file that I could copy and paste back into the workbook.
VBZ is my curiosity not my strength.
Any help is appreciated.

 

[Eric W]

Welcome to the forum.

How about:

Sub ShowProperties()
Dim strProperty

    On Error Resume Next
    
    With Sheets.Add
        r = 1
        For Each strProperty In ThisWorkbook.BuiltinDocumentProperties
            .Cells(r, "A") = strProperty.Name
            .Cells(r, "B") = strProperty.Value
            r = r + 1
        Next strProperty
    End With
        
End Sub

Let me know if you need instructions how to use it.

 

[smhish]

While I may look like I am sitting at my desk grinning...i am dancing down the hall yelling hallejuiahs shocking my neighbors!
Thank you!

Welcome to the forum.

How about:

Sub ShowProperties()
Dim strProperty

    On Error Resume Next
    
    With Sheets.Add
        r = 1
        For Each strProperty In ThisWorkbook.BuiltinDocumentProperties
            .Cells(r, "A") = strProperty.Name
            .Cells(r, "B") = strProperty.Value
            r = r + 1
        Next strProperty
    End With
        
End Sub

Let me know if you need instructions how to use it.

 

[Eric W]

Your neighbors need to be shocked once in a while, keeps them on their toes!

Glad I could help!