I want to do the same as the includetext or includepicture with if field from
Word's Mail Merge: a single value (cell value for example) changes a linked
picture (includepicture) or document(includetext).
I only know this with Image OLE from control toolbox and loadpicture on VBA.
Is there a solution without using the VBA?

If this DDE link can be changed automatically, a lot of applications can be
done with this resource, because not only Paint.Picture can be done, but
Word.Document.8, Excel.Sheet.8, and others.

Thanks

"NickHK" wrote:

Harlan,
Curious as to where DDE fits into the picture of OLE objects communicating ?

NickHK

"Harlan Grove" wrote in message
...
"Anderflash" wrote...
...
I want to know if can I use a function or a named range to interact with
a
linked object inserted by Insert - Object (Option 'Link to file').
After, I
want to change the object according to a cell's value (for instance: if
A1 =
1, then the object will show document1.doc, if A2 = 2, object will show
document2.doc, and so on)

No. You could use macros to change the formulas that define such links to
objects, but there's no way to make the link formulas dynamic.

When I insert the linked object, the formula bar shows
=Word.Document.8|'C:\Documents and Settings\UserName\Desktop\New
Folder1\document1.doc'!''''

Is there a way to interact with this string?

No. The only option is using macros to change such formulas.

And can someone explain me this string format? And the pipe ( | )
function
and another parts of the string...

Read the online help topic titled 'Create a link using Dynamic Data
Exchange
(DDE)'.