ExcelBanter - Automate: Excel cell to Word?

If you want a stable version of the document, break the link - select the
linked item and press CTRL+SHIFT+F9
I don't know Excel well enough to advise on how to handle versions, but if
you want to have different versions of the spreadsheet and retain the links,
I would imagine that you would have to create dated copies of the sheets and
link them to the documents, so each pairing stands independently. I have
cross-posted to an Excel group for their input.

--
<< << << << << << <<<
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<< << << << << << <<<

LF wrote:
I asked:
I have a boilerplate in Word that produces a report in letter form.
I
have a spreadsheet in Excel that produces numbers. <snip I'd like
to automate the process.

On Mar 7, 1:15 am, "Graham Mayor" wrote:
Open the spreadsheet
Copy the cell(s) to the clipboard
Open the document
Place the cursor at the location you want the cell(s) to appear
Edit Paste Special - choose the format that gives the results you
require (probably the default html) and check the paste link box.
The link will be constantly updated whilst the document and
spreadsheet are open, or if the spreadsheet is closed, when you
select the link and click F9.

Graham,
Many thanks. Your advice worked. I just didn't get it before -- with
the help of internet searches, help files, and a couple MS Office
books.
Now, I'm wondering, is there a way to save electronic versions of the
different versions of the temporary spreadsheets? I see that I can
maintain a stable version of the Word document, simply by not updating
it if I open the file at a later date. What if I want a stable copy
of the spreadsheet as it existed with that particular document?

Best,
Larry