This question was at the end of another thread, but I felt it more appropriate to re-title it and put
it under a new thread because the original question doesn't really apply anymore.
I have the interesting task of
exporting each rows value in Excel to a particular field in Word. I have attached a workbook to show what I mean.
I have text totals on a single worksheet and need a way to do the following...
1. Somehow, with code say
"If column A3 says "Chunky Closed", column C3 should say
"If column A4 says "Chunky Dented", column C4 should say "FIELD 02"
etc, etc for all 18 columns, using columns E & F as a reference to the Word Document.
2. Somehow, through
code from Excel or code from Word, both, or the next best way, (mail merge maybe?) put the totals from B into the Word
document, using column C to index or match it.
Questions I pondered myself while thinking about this
>Can Excel/Excel VBA open up Word, if yes, a particular document?
>Can Excel or Word exchange desired areas of text/totals through code?
>If yes, can Excel tell Word to close and save the document under a new name?
Picture the Word Document like a
letter that you "TAB" through. Basically, I have a letter and just inserted 18 text form fields and then locked
these form fields with the lock button on the Form toolbar. I suppose I should've put "Text Form Field" in the
workbook instead of "Field" but at least now you know.
If something other than text form fields should
be there instead so that Excel and Word can speak correctly, no problem. I'd be happy to change them from Text Form Fields to
anything...such as a FIELD for example. I'm not sure the best route for that.