Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function in objects.
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function in objects.
"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)'. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function in objects.
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? "Harlan Grove" wrote: "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)'. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function in objects.
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)'. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function in objects.
"NickHK" wrote...
Curious as to where DDE fits into the picture of OLE objects communicating ? .... I was responding to the syntax. When I insert the linked object, the formula bar shows =Word.Document.8|'C:\Documents and Settings\UserName\Desktop\New Folder1\document1.doc'!'''' .... 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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function in objects.
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)'. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My objects are disappearing! | Charts and Charting in Excel | |||
How to get rid of web page objects ? | Links and Linking in Excel | |||
Non-Printing Objects | Excel Discussion (Misc queries) | |||
Grouping and Objects | Excel Discussion (Misc queries) | |||
VBA Objects | Excel Discussion (Misc queries) |