If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Link 'Excel Object in Word' to Excel
I have a Word document which contains several embedded Excel objects which is
sent to 600 clients. The clients complete the data collection in the word document and send back. We have a Excel worksheet for each client that uses the data in the embedded Excel objects. Is there a way to "link" or transfer the data in the 'Excel Object in Word' to the appropriate cells in the Excel worksheet? Because each Word document is customized for each client using Mail Merge and an Access database, and because there is much verbage and many sections in the document sent to the client, sending an Excel worksheet to the client is not an option. I'd prefer some sort of direct link (but I have not been successful at that). I'm OK with VBA so that is an option. Any ideas? Thank you in advance, Robin |
Thread Tools | |
Display Modes | |
|
|