Thread: [Solved] merging whole documents?
View Single Post
 
Old 02-03-2012, 04:04 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Adam,

It would probably be possible to use a Word macro(vba) to add the graph to the document, either at print time (perhaps without even saving the changed document), or at some earlier time. Before commenting further, though, I'd need to know whether there's anything in the Word document that can be used to identify the relevant Excel file, whether the Word and Excel files are stored in the same folders or if there's at least a pattern to identifying the path to the folder(s) in which the Excel files are stored, how the Excel files are structured (eg is the graph on the same page as the data, or on a separate sheet).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote