A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Automate: Excel cell to Word?



 
 
Thread Tools Display Modes
  #1  
Old March 8th, 2009, 07:49 AM posted to microsoft.public.excel,microsoft.public.excel.links,microsoft.public.excel.misc,microsoft.public.word.docmanagement
Graham Mayor
external usenet poster
 
Posts: 18,297
Default 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



  #2  
Old March 8th, 2009, 04:36 PM posted to microsoft.public.excel,microsoft.public.excel.links,microsoft.public.excel.misc,microsoft.public.word.docmanagement
LF[_2_]
external usenet poster
 
Posts: 5
Default Automate: Excel cell to Word?

On Mar 8, 2:49*am, "Graham Mayor" wrote:
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,

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

Best,
Larry
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:04 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.