Isert Object - Excel question

[Salad]

Hi. We have a generic Word template. When we create a new document, we
make a copy of the Word template and then do a mail merge. This mail
merged docoment now becomes a generic template to be used with similar
records.

We now would like to insert an excel object. Currently, when we insert
the Excel spreadsheet, it presents a bunch of blank rows besides the
rows we want to work with. For example, if the spreadsheet uses Rows
A1..E25 for data entry, when we bring in the spreadsheet we have all
available rows. And the object, when it prints, prints a blank page.
We only want to work with the first 25 rows. How can we insert just the
rows necessary for the spreadsheet and be able to modify the values?

Also, any data that we save in the Excel document that was inserted in
Word should not affect the original Excel template. So...let's say we
have an Excel spreadsheet named MasterOrderTemplate.XLS. We would like
that to be inserted in our generic Word Template. We then copy the
generic word template to ABCTemplate.Doc. We now open up
ABCTemplate.Doc, move to the Excel object, change some data, and then
save/print the Word document. The data in the Excel object should not
update the original MasterOrderTemplate.XLS. Is this possible?

 

[Cindy M -WordMVP-]

Hi Salad,

We now would like to insert an excel object. Currently, when we insert
the Excel spreadsheet, it presents a bunch of blank rows besides the
rows we want to work with. For example, if the spreadsheet uses Rows
A1..E25 for data entry, when we bring in the spreadsheet we have all
available rows. And the object, when it prints, prints a blank page.
We only want to work with the first 25 rows. How can we insert just the
rows necessary for the spreadsheet and be able to modify the values?

Easiest, really, is to use copy/paste to insert exactly the Excel range
you're interested in. You can use Edit/Paste Special to insert it as an
object, rather than a Word table. Just be careful to NOT activate "Link" in
order to not affect the original Excel sheet you took it from.

The data in the Excel object should not
update the original MasterOrderTemplate.XLS.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail