Linked objects change size

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.
 

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

Top