Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 -- jujuwillis ------------------------------------------------------------------------ jujuwillis's Profile: http://www.excelforum.com/member.php...fo&userid=2123 View this thread: http://www.excelforum.com/showthread...hreadid=391762 |
#2
|
|||
|
|||
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" wrote 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...fo&userid=2123 | View this thread: http://www.excelforum.com/showthread...hreadid=391762 | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Where does Excel get the default properties without startup file? | Excel Discussion (Misc queries) | |||
Printing/Displaying File Properties | Excel Discussion (Misc queries) | |||
Can I display the file properties of a workbook in a custom headi. | Excel Worksheet Functions | |||
How do I show some of the file properties in a cell in a work she. | Excel Worksheet Functions | |||
Deleting custom Commands from File Menu are nor saved next time w. | Excel Worksheet Functions |