Hi,
I´m trying to link a excel document to a word document.
The problem is that I want to collect the document name in a field, which resideces in the Link. This works perfect one time, but the next time the field has disappeared and been replaced with the actual document name.
Ex Before:
{ LINK Excel.Sheet.8 { REF DocumentName \h \* MERGEFORMAT } System!domain \a \t \* MERGEFORMAT }
This collects the DocumentName value, as it should...but as said...the next time the Link gets updated the REF DoumentName has already been replaced by the definite path to the Document.
Ex After:
{ LINK Excel.Sheet.8 "C:\\Path\\to\\my\document\\My.xls System!domain \a \t \* MERGEFORMAT }
br
- Petter
I´m trying to link a excel document to a word document.
The problem is that I want to collect the document name in a field, which resideces in the Link. This works perfect one time, but the next time the field has disappeared and been replaced with the actual document name.
Ex Before:
{ LINK Excel.Sheet.8 { REF DocumentName \h \* MERGEFORMAT } System!domain \a \t \* MERGEFORMAT }
This collects the DocumentName value, as it should...but as said...the next time the Link gets updated the REF DoumentName has already been replaced by the definite path to the Document.
Ex After:
{ LINK Excel.Sheet.8 "C:\\Path\\to\\my\document\\My.xls System!domain \a \t \* MERGEFORMAT }
br
- Petter