Automate: Excel cell to Word?

[LF]

I have a boilerplate in Word that produces a report in letter form. I
have a spreadsheet in Excel that produces numbers. Now, I first print
out the spreadsheet, then manually type individual numbers from
individual Excel cells into the Word document. I tried to automate
this with "link" and "embed" into "fields" -- but failed.

I use the same Word boilerplate over and over to produce reports. I
use the same Excel spreadsheet over and over to get the numbers for my
Word reports. I'd like to automate the process.

Any pointing in a helpful direction will be greatly appreciated.

Best,
Larry

 

[Graham Mayor]

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 Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[LF]

I asked:

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

 

[Graham Mayor]

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[LF]

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.

Thanks again. This will save me several hours each week.

Best,
Larry