Hi everyone, I've done some searching but have not found an easy solution to this one.
I have a parent Excel file, that feeds a child Word file. I spent a lot of time coding a macro so that the Excel file can keep the links in the Word file pointing to it, as these files will be used by different people on different machines to produce reports. Basically there's a button in my excel file, it opens up a file browse menu, you choose the child word.doc template, it then opens it, looks for any Excel Link fields and changes the underlying code of the field to ensure it is pointing back at the parent excel file after file names or paths have been changed.
It's fragile, but it all seems to work just fine now. (BTW, I would have left the entire resulting document in Excel, but the user I'm developing it for insists it be put into word~)
One thing that I notice though, is after an update, all the charts look like they've been compressed.
I've toyed around with settings to try to prevent this compression. To no avail though. Is there something I can do to reset the chart to it's original state without any compression?
Edit: I'm using Excel & Word 2007. That might be useful info~
I have a parent Excel file, that feeds a child Word file. I spent a lot of time coding a macro so that the Excel file can keep the links in the Word file pointing to it, as these files will be used by different people on different machines to produce reports. Basically there's a button in my excel file, it opens up a file browse menu, you choose the child word.doc template, it then opens it, looks for any Excel Link fields and changes the underlying code of the field to ensure it is pointing back at the parent excel file after file names or paths have been changed.
It's fragile, but it all seems to work just fine now. (BTW, I would have left the entire resulting document in Excel, but the user I'm developing it for insists it be put into word~)
One thing that I notice though, is after an update, all the charts look like they've been compressed.
I've toyed around with settings to try to prevent this compression. To no avail though. Is there something I can do to reset the chart to it's original state without any compression?
Edit: I'm using Excel & Word 2007. That might be useful info~
Last edited:
