How to Transfer data from Text Form Fields in MS Word into Excel?
I am Using Microsoft Office Excel 2002 and Microsoft Office Word 2002. My
Word document has Text Form Fields. I would like to be able to transfer data from these text fields into Excel. I would also like to transfer data from Excel into the text fields. How do I do this? |
How to Transfer data from Text Form Fields in MS Word into Excel?
Hi C Willis... For Excel and word interaction you can use macros. If there is a word document having form fields then you can search the form fields using bookmarks defined for that form field and then create an excel object and insert in the sheet. I have done a similar kind of thing using word macros. It created a new word document with dynamically generated text form fields with values from excel sheet. Hope it helps. Monika CWillis Wrote: I am Using Microsoft Office Excel 2002 and Microsoft Office Word 2002. My Word document has Text Form Fields. I would like to be able to transfer data from these text fields into Excel. I would also like to transfer data from Excel into the text fields. How do I do this? -- movi1982 ------------------------------------------------------------------------ movi1982's Profile: http://www.excelforum.com/member.php...o&userid=36423 View this thread: http://www.excelforum.com/showthread...hreadid=543829 |
All times are GMT +1. The time now is 10:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com