I am in the process of coding a worksheet that stores and retrieves data from
the ContentTypeProperties (if in Office 2007) , the
BuiltinDocumentProperties, and the CustomDocumntProperties. Since many
personnel in our company still use Office 2003, the code to access
ThisWorkbook.MetaProperties is not available and is causing a compile error
on those machines. I found an article stating that the use of
#IF...#ELSE...#END IF could be used to "skip" the compiling of that code if
the machine did not have Office 2007 installed and when I used it on an
Office 2003 machine, it did just that; however, when I use the code on an
Office 2007 machine, it works the opposite way (i.e. True statements execute
as false and vice-versa). Can anyone assist?