I think this should be easy but my brain forgets too easily !! Office 97 by the way.
I have several cells and chart objects from workbooks linked (together) into one word document. Code in one of the excel sheets does some manipulation on the underlying data. I wish to update the links (if necessary?)into word and print out at each iteration of data changed by the code in excel.
How can I do this preferably without actually opening word as an application. I have the code for the printer setting that I can add in afterwards.
I have several cells and chart objects from workbooks linked (together) into one word document. Code in one of the excel sheets does some manipulation on the underlying data. I wish to update the links (if necessary?)into word and print out at each iteration of data changed by the code in excel.
How can I do this preferably without actually opening word as an application. I have the code for the printer setting that I can add in afterwards.
