#IF Statement in Excel
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? |
All times are GMT +1. The time now is 12:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com