Functions in objects

A

Anderflash

Well, I know that we can use a named range with a offset function in a SERIES
function of 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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function in objects. 5
Excel - Wich Function should I use? 1
How to modify and updte specific styles for specific paragraphs across the document 0
Pivot Chart on the Web with interactivity... 1
OLE Help 0
Combining word documents in VB.NET 1
Document Name Doesnt Reflect what is Opened 1
Inserting an object that works like a hyperlink 4

Top