Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
#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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
sql statement being run from vba excel | Excel Programming | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions |