ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to Transfer data from Text Form Fields in MS Word into Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/89609-how-transfer-data-text-form-fields-ms-word-into-excel.html)

CWillis

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?

movi1982

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