Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.links,microsoft.public.excel.misc,microsoft.public.word.docmanagement
external usenet poster
 
Posts: 7
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   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.links,microsoft.public.excel.misc,microsoft.public.word.docmanagement
external usenet poster
 
Posts: 2
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automate: Excel cell to Word? Graham Mayor Excel Discussion (Misc queries) 1 March 8th 09 04:36 PM
make cell equal a word if a data validation cell has a word in it Robzz Excel Discussion (Misc queries) 1 February 6th 09 07:20 PM
Automate cell WANTED Excel Discussion (Misc queries) 2 May 18th 07 01:26 PM
Automate cell splitting Bill G. Excel Discussion (Misc queries) 1 May 17th 07 05:20 PM
Automate new Word file and insert autotext leaftye Excel Discussion (Misc queries) 2 November 7th 06 07:21 PM


All times are GMT +1. The time now is 03:38 PM.

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

About Us

"It's about Microsoft Excel"