![]() |
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 |
All times are GMT +1. The time now is 04:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com