Retrieving custom document properties - Excel 2007

[Barb Reinhardt]

--
HTH,
Barb Reinhardt

 

[Barb Reinhardt]

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

 

[Jim Rech]

Every time I open EXcel 2007 it shows COMPATIBILITY mode at the top, so I
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
| 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
|
|

 

[Barb Reinhardt]

I get Runtime error 429. ActiveX component can't create object

Barb Reinhardt