Hi Peter,
With the field code, you must have a space either side of the '0'. Spaces for the rest are inconsequential and your field code could be reduced to:
{IF{LINK Excel.Sheet.8 "C:\\Documents and Settings\\*FAKE FOLDER\\FAKEFILE.xlsx" "Sheet1!R2C1:R2C3" \a \f 4 \r}> 0 "Field1: {LINK Excel.Sheet.8 "C:\\Documents and Settings\\*FAKE FOLDER\\FAKEFILE.xlsx" "Sheet2!R1C1:R4C4" \a \f 4 \r}"}
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|