Using a LINK field inside an IF field

B

Byron

I have a word document that has several LINK fields in it that point to
individual cells in an excel workbook. The LINK fields work fine by
themselves, but not when I try to use them inside an IF field. Here is the
process I am currently using to attempt to insert the fields:

I go to the place in the word document that I want the field and select
Insert > Field... from the menue bar.
Then I click the Field Codes button in the bottom right.
Then I paste the following text into the Field Codes field:

IF { LINK Excel.Sheet.8 "C:\\Documents and
Settings\\Username\\Desktop\\Proposal Work (Fields)\\Pricing Model.xls" "PW
Pricing!Address2" } = "" "" " "

Any suggestions on how to get this to work would be appreciated. Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top