Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
TishyMouse TishyMouse is offline
external usenet poster
 
Posts: 7
Default Using a conditional parameter within the LINK field

I have a Word document that includes links to a number of tables in an Excel
spreadsheet. The links are defined in terms of defined names in the
spreadsheet. I'd like to be able to link to different tables depending on the
value of a custom property in the Word document but I can't get this to work.

e.g. the following works OK:
{LINK Excel.Sheet.8 \\\\domain.com\\mypath\\MyExcelFile.xls MySheet!Name_UK
\f 0 \p}

but I'd like to use something like
{LINK Excel.Sheet.8 \\\\domain.com\\mypath\\MyExcelFile.xls
MySheet!Name_{DOCPROPERTY Region} \f 0 \p}

Where the names Name_UK, Name_US etc. are defined within the Excel sheet and
'Region' is a property of the Word document.

However it doesn't work at least with this syntax (I just get an 'Error! Not
a valid link' message). Does Word actually support this or does anyone know a
different way to implement this functionality? I realise one alternative
would be to have a number of nested {IF } statements for the different
regions but that will get very messy and hard to maintain.


TIA

TishyMouse
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Using a conditional parameter within the LINK field TishyMouse Microsoft Word Help 10 March 23rd 10 11:09 AM
conditional field layouts Peter Mailmerge 2 September 14th 09 04:15 AM
Conditional Wordart via Mailmerge-Field? Lüko Willms Mailmerge 3 October 13th 06 04:57 AM
Link a Field to an Embedded Worksheet & have the link follow "save Drew Microsoft Word Help 1 October 6th 06 10:13 AM
Conditional merging a field and formating it [email protected] Mailmerge 1 April 7th 06 08:02 PM


All times are GMT +1. The time now is 10:12 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"