P
Paul DeMarco
When you want to specify a chart in excel you use something similar to:
[filename]sheet_name chart_name
why is the filename there? worse yet, the oleformat.label property for a linked chart from word->excel uses:
sheet_name![filename]sheet_name chart_name
The problem with all this is what when the linkformat.sourcefullname property on that linked chart changes in word, it cannot find the new chart because the oleformat.label property still contains the old filename.
so how is someone supposed to go about changing the filename that a linked chart refers to? the oleformat.label property is readonly. I do not think I can simply remake the oleformat object, although that would be suitable.
I realize I could completely recreate the linked chart in word, but the list of properties and child objects to copy settings from would be immense to guarantee that everything was replicated as is.
any suggestions on how to go about this pseudo-efficiently would be great. thanks.
[filename]sheet_name chart_name
why is the filename there? worse yet, the oleformat.label property for a linked chart from word->excel uses:
sheet_name![filename]sheet_name chart_name
The problem with all this is what when the linkformat.sourcefullname property on that linked chart changes in word, it cannot find the new chart because the oleformat.label property still contains the old filename.
so how is someone supposed to go about changing the filename that a linked chart refers to? the oleformat.label property is readonly. I do not think I can simply remake the oleformat object, although that would be suitable.
I realize I could completely recreate the linked chart in word, but the list of properties and child objects to copy settings from would be immense to guarantee that everything was replicated as is.
any suggestions on how to go about this pseudo-efficiently would be great. thanks.