View Single Post
 
Old 02-25-2011, 04:37 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,224
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Hi rtlight,

What you're now describing really isn't a reusable document - it's a document template.

If you've got links, there is no way to hide them from the users. Plus, the template approach won't work happily with links to different Excel workbooks. The solution I posted is really only viable for a document that links to a workbook whose name & path remains unchanged - only the linked data in the referenced range changes.

What might work (if you create a Word mailmerge document and a generic Excel workbook in a suitable folder) is to copy the various Excel workbooks over the generic one, execute a mailmerge and save the mailmerge output back to the client folders. That way, there'll be no links etc in the output file. You would, of course, need to have a worksheet in the workbook laid out with the data all on one row for the mailmerge, but that is fairly easy to set up.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote