Custom File Properties

J

jujuwillis

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
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 Willi
 
J

Jim Rech

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
in message |
| 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?action=getinfo&userid=2123
| View this thread: http://www.excelforum.com/showthread.php?threadid=391762
|
 
Top