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