Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieving custom document properties - Excel 2007
-- HTH, Barb Reinhardt |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieving custom document properties - Excel 2007
Here's the rest of my message.
I've used VBA in Excel 2003 to retrieve Custom document properties and it works well. However, when I'm testing my file in 2007, it gets held up here Set objDocProperties = CreateObject("DSOFile.OleDocumentProperties") I've got the reference set for DSO OLE Document Properties reader 2.1 within the VBE In this KB article ( http://support.microsoft.com/kb/224351 ) it states that it should work if I have the compatibility pack installed. Every time I open EXcel 2007 it shows COMPATIBILITY mode at the top, so I have to assume it's there. Can someone assist? I use this macro once a month to pull data for an operations review and there is no way I can go back to doing it manually. Thanks, Barb Reinhardt |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieving custom document properties - Excel 2007
Every time I open EXcel 2007 it shows COMPATIBILITY mode at the top, so I
have to assume it's there. Compatibility mode is different that the Compatibility Pack. If you have the later installed you can open Excel 2007 files (XLSX, etc.) in Excel 2003. If in doubt try to install it again. -- Jim "Barb Reinhardt" wrote in message ... | Here's the rest of my message. | | I've used VBA in Excel 2003 to retrieve Custom document properties and it | works well. However, when I'm testing my file in 2007, it gets held up here | | Set objDocProperties = CreateObject("DSOFile.OleDocumentProperties") | | I've got the reference set for DSO OLE Document Properties reader 2.1 | within the VBE | | In this KB article ( http://support.microsoft.com/kb/224351 ) it states | that it should work if I have the compatibility pack installed. Every time I | open EXcel 2007 it shows COMPATIBILITY mode at the top, so I have to assume | it's there. | | Can someone assist? I use this macro once a month to pull data for an | operations review and there is no way I can go back to doing it manually. | | Thanks, | | Barb Reinhardt | | |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieving custom document properties - Excel 2007
I get Runtime error 429. ActiveX component can't create object
Barb Reinhardt "Chip Pearson" wrote: The following works for me. If you have a reference set to the DSO 2.1 library, you can explicitly declare the variable rather than using CreateObject. Dim DSO As DSOFile.OleDocumentProperties Set DSO = New DSOFile.OleDocumentProperties DSO.Open "C:\Books.xls" Debug.Print DSO.CustomProperties("TestProp") Debug.Print DSO.SummaryProperties.Author DSO.Close With CreateObject, use Dim DSO As Object Set DSO = CreateObject("DSOFile.OleDocumentProperties") DSO.Open "C:\Books.xls" Debug.Print DSO.CustomProperties("TestProp") Debug.Print DSO.SummaryProperties.Author DSO.Close What error do you get (or do you just get no property values) when you run the code in 2007? -- Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) "Barb Reinhardt" wrote in message ... Here's the rest of my message. I've used VBA in Excel 2003 to retrieve Custom document properties and it works well. However, when I'm testing my file in 2007, it gets held up here Set objDocProperties = CreateObject("DSOFile.OleDocumentProperties") I've got the reference set for DSO OLE Document Properties reader 2.1 within the VBE In this KB article ( http://support.microsoft.com/kb/224351 ) it states that it should work if I have the compatibility pack installed. Every time I open EXcel 2007 it shows COMPATIBILITY mode at the top, so I have to assume it's there. Can someone assist? I use this macro once a month to pull data for an operations review and there is no way I can go back to doing it manually. Thanks, Barb Reinhardt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I embed SharePoint document properties in Excel 2007? | Excel Discussion (Misc queries) | |||
Document Properties for Office 2007 Excel Templates | Excel Discussion (Misc queries) | |||
dont see custom document properties... | Excel Programming | |||
How can I using Excel custom document properties in the header? | Excel Worksheet Functions | |||
Accessing custom document properties | Excel Programming |