Auto build a Word document using Exel entries

[Guest]

I would like to be able to have Excel and Word interact in automatically
developing proposal documents based on entries into an Excel. Example: I
enter a 1 in an excel spreadsheet cell with a description of design/build
services with and associated cost of $1,500. This entry on the spreadsheet
would trigger an automatic entry to display in a Word document that would
state the desired verbiage for the design build entry in the spreadsheet. The
desired outcome would be that we would be building the proposal/contract in
Word as we complete the estimate in Excel. Is this at all possible?

 

[Jay Freedman]

I would like to be able to have Excel and Word interact in automatically
developing proposal documents based on entries into an Excel. Example: I
enter a 1 in an excel spreadsheet cell with a description of design/build
services with and associated cost of $1,500. This entry on the spreadsheet
would trigger an automatic entry to display in a Word document that would
state the desired verbiage for the design build entry in the spreadsheet. The
desired outcome would be that we would be building the proposal/contract in
Word as we complete the estimate in Excel. Is this at all possible?

It's possible, in the sense that building a house by yourself is
possible. These articles discuss programming macros in Word and Excel
for either program to control the other, in general terms:
http://word.mvps.org/FAQs/InterDev/ControlXLFromWord.htm
http://word.mvps.org/FAQs/InterDev/ControlWordFromXL.htm

However, there are many pitfalls, and it's usually better to let an
expert set something up for you. In this case the expert is MVP Bill
Coan, whose company sells a product named DataPrompter that builds
documents from predefined pieces:
http://www.wordsite.com/products/dpdas.htm
If it isn't quite what you need, contact Bill through his web site and
ask about customizations.