Custom File Properties

Can you help?

I use a template that has custom properties linked to the cells.
Is there anyway I can either extract those particular properties to a list
I don't what to data track the information using the template wizard, just a straight forward list or this my only option?

Julie Willis

You'd need a macro to make the list.

Sub ListCustProps()
Dim Counter As Integer
With ActiveWorkbook
For Counter = 1 To .CustomDocumentProperties.Count
Cells(Counter, 1).Value = .CustomDocumentProperties(Counter).Name
Cells(Counter, 2).Value = .CustomDocumentProperties(Counter).Value
Next
End With
End Sub


--
Jim
"jujuwillis" <[email protected]> wrote
in message news:[email protected]...
|
| Can you help?
|
| I use a template that has custom properties linked to the cells.
| Is there anyway I can either extract those particular properties to a
| list
| I don't what to data track the information using the template wizard,
| just a straight forward list or this my only option?
|
| Julie Willis
|
|
| --
| jujuwillis
| ------------------------------------------------------------------------
| jujuwillis's Profile:
http://www.excelforum.com/member.php...fo&userid=2123
| View this thread: http://www.excelforum.com/showthread...hreadid=391762
|