P
Paul DeMarco
When changing the size of a linked object in a word document (that has been resized), it reverts to its full size. Is there anyway to preserve its position and size, without having to reset them after changing the linkformat.sourcefullname.
Also, since that makes 2 questions, heres the 3rd and final problem
When you want to programatically change the source data range for a series on an excel chart, it becomes difficult because it doesn't expose the existing source range as a range, simply as a string. but that would be less then convenient to parse, is there an easy way to get that into a range object, so that things like its sheet, and cells are easily accessible. once that information is there, then its easy to create a new range and set it as the new source data range for the chart series.
Also, since that makes 2 questions, heres the 3rd and final problem
When you want to programatically change the source data range for a series on an excel chart, it becomes difficult because it doesn't expose the existing source range as a range, simply as a string. but that would be less then convenient to parse, is there an easy way to get that into a range object, so that things like its sheet, and cells are easily accessible. once that information is there, then its easy to create a new range and set it as the new source data range for the chart series.