Thread: How do I link multiple cells to edit parts of an embedded object?

I need to find a way to place MS Word docs into their own Excel sheets in one workbook. I then have a master sheet with names and what not that I need to be able to use to update the names in the docs.

Right now I'm trying to use embed object to place the Word doc onto a sheet. I can't figure how to have one cell update just a person's name in the object though. Is this possible?

I'm not even sure this is the route I want to go. When I use embed object it doesn't place the documents header in the Excel sheet. Very frustrating. My boss insists there is a way to do this and he must not be the first one who has wanted to do it. Although he pawned it off on me haha. Any help would be greatly appreciated. At least point me in the right direction. I'm good with Google.

No, I don't believe mail merge would work. The Word docs are appointment memorandums. So when an appointment changes, the name in the Word doc needs to be changed along with various other things; such as the date, rank, SSN and such.

There are around a hundred of these documents so its pretty tedious to go in and update them one by one. Placing them all in excel would be nice because then they are all in one application using the sheets. I can then just copy and paste all the info from a master sheet and link the date and signature block so that will change all at once.

I had gone through and manually typed all of the documents into Excel which took me forever and had it working for the most part. I then tried to email the workbook to my boss and come to find out the links don't transfer to other computers. So yeah, back to square one.

If nobody knows a good way to do this then the main thing would be updating the signature block in word documents across multiple docs at once. Maybe I will try for that in the Word forum if I don't have any luck here after a few days.