![]() |
#5
|
|||
|
|||
![]()
OK, now I think I understand.
{ IF { LINK Excel.Sheet.8 "C:\\Documents and Settings\\*FAKE FOLDER\\FAKEFILE.xlsx" "Sheet1!R2C1:R2C3" \a \f 4 \r \* MERGEFORMAT } > 0 "Field1: { LINK Excel.Sheet.8 "C:\\Documents and Settings\\*FAKE FOLDER\\FAKEFILE.xlsx" "Sheet1!R2C1:R2C3" \a \f 4 \r \* MERGEFORMAT} " "" } Again, I think you would be better off using mail merge structure rather than link. The line above inserts your value from your spreadsheet if that value is greater than 0, together with an identifier "Field1: " here. It also inserts a new paragraph. If the value is blank or not greater than 0, it will not insert anything. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
External/Embedded links to excel | lucas | Word | 3 | 03-30-2012 01:47 PM |
Edits links to Excel file in PowerPoint | ziba | PowerPoint | 4 | 01-09-2012 08:48 AM |
Powerpoint 2010 losing links to excel | Hans_b | PowerPoint | 0 | 07-12-2011 04:19 AM |
Updating Excel Chart Links | fermat | PowerPoint | 0 | 07-09-2010 04:29 PM |
Break Links with Excel | streng | Word | 0 | 06-29-2009 02:43 AM |