If you are using 64 bit Office 2010 that'll be the reason. Unfortunately Com
& ActiveX (which is what that dll is) will not be supported, a major problem
for some. However
AFAIK it should work in 64 bit windows with 32 bit Office,
but I can't test.
Regards,
Peter T
"Bill Brunt" wrote in message
...
Hi -
I'm getting the error "The document is not an OLE file, and does not
support
extended document properties" when I query the custom properties in an
Excel
2007 using http://support.microsoft.com/default.aspx/kb/224351?p=1. The
same
VBA code works fine when I run on 32 bit versions of Windows 2003 and
Windows
Vista but I get that error when I run on 64 bit version of Windows 7.
I don't know how many folks are running 64 bit Windows 7 but I do know it
will be more and more and am hoping to fix as I cannot run on my laptop.
- Bill