Adding a Word document to Excel and updating

[aiwnjoo]

Hi,

Not posted here in a while, I have come into a new problem I am trying to figure out.

I know I can create links between documents but I would like to do the following;

1: Excel Worksheet with Excel data on Sheet1
2: Word Document inserted into Sheet2 without linking to Word, so an actual Word document as Sheet2.
3: I would then perform a calculation in Sheet1 and the summary I would like to be displayed in the Sheet2 Word document.

History behind this;

Sheet1 is an Excel Income & Expenditure Form, once the form is created we will be sending a letter to each customer which will have information based on figures the I+E Form gives us but instead of manually updating the letter I want it automated based on the I+E Form.

Is this possible, and any suggestions?

Thanks guys,

 

[aiwnjoo]

Ok here is an update with an example;

http://www.box.net/shared/u2ri806tsecrx2yrekra

I would create a macro button which would automatically load the word document and apply the changes from excel, print and close.

Thanks very much,

 

[aiwnjoo]

Bump

 

[aiwnjoo]

Do you think it is a better idea just to write the document in excel making it look like the letter, then use regular formulas to fill things in.

Simple, Silly, but easier and should still print out the same.

 

[aiwnjoo]

Bump