Function in objects.

[Anderflash]

Well, I know that we can use a named range with a offset function in a SERIES
function from a chart. So, the chart will have more interactivity.

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)

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?

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

Thanks

 

[Harlan Grove]

...
....

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)'.

 

[Anderflash]

I did this macro/VBAcode to change the formula property of the object. Even
formula or formulaRC cause an error when I execute the macro/VBA code.

And If I use the XLM macro sheet, will this sheet interact with the object
properties, like this link formula and other properties?

 

[NickHK]

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

NickHK

 

[Harlan Grove]

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

....

I was responding to the syntax.
....

Maybe the menu command that produces linked objects uses the term Object,
but I doubt it uses the term OLE. Regardless, the formula above is in DDE
link syntax. As for why that may be so, I dunno. Ask a MSFT employee.

 

[Anderflash]

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