Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 04-23-2012, 09:49 AM
Charles Kenyon Charles Kenyon is offline Advanced Question about Links to Excel Windows Vista Advanced Question about Links to Excel Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,533
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Quote:
Originally Posted by peterock View Post
How do I insert my previous link to exist as Field1?
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.
Reply With Quote
 



Similar Threads
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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:05 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft