Populating a document with Excel

[Heather]

Is there a way to populate a Word document automically from an excel document

Is there a way to populate a Word document such that it builds a summary
table
Example:
Edition: Nuc Graphics-Any OS
Item PN Desc Qty List Price Extended Price
1 ABCDE Desc A 1 10,000 10,000
2 PN 1 Desc B 1 $2,500 $2,500
3 PN2 Desc C 1 $5,000 $5,000

and so on

 

[DaveLett]

Hi Heather,
Yes, and an excellent starting point is "How to Control Excel from Word" at
http://word.mvps.org/FAQs/General/index.htm

HTH,
Dave

 

[Heather]

thank you -- I was hoping for maybe something a little simplier? but maybe
this is how I need to do it ?

 

[Peter Jamieson]

You /may/ be able to use Word's Insert->Database command to insert a
table containing selected records and columns from an Excel sheet or
named range, or a { DATABASE } field that will do the same thing so the
content can easily be "refreshed", but
a. in Word 2007 the option is not in the Ribbon (which should warn you
that it is no longer considered to be a commonly used feature) - you
should be able to find it in Word Office Button->Word
Options->Customize->then select All Commands. In Word 2003 and earlier
it's on the Database toolbar.
b. you don't get much control over the table layout or data formatting
as you insert the data
c. if by summary you mean that you need to sum some values in the
source worksheet, you will need to insert the database as a DATABASE
field, then modify the generated SQL to sum/count what you need. You
might also need to do that to format the data how you need.


Peter Jamieson

http://tips.pjmsn.me.uk