ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Copy data from Microsoft Word form into Excel (https://www.excelbanter.com/excel-programming/404469-copy-data-microsoft-word-form-into-excel.html)

Amanda

Copy data from Microsoft Word form into Excel
 
Hi

I have a form in Word with various drop down options, check and radio boxes.
I would like to store the information into Excel. The initial form will be
emailed out to numerous people, therefore I need to be able to capture all
data, from numerous forms, into 1 excel spreadsheet?

I'm guessing I will need to be able to program, and guess what? I can't!
arrrgghh. Any help would be appreciated.

Cheers
Amanda
U.K.

ryguy7272

Copy data from Microsoft Word form into Excel
 
Yep, you need to know VBA, but it's not too bad. This should get you started:
http://word.mvps.org/FAQs/InterDev/C...WordFromXL.htm

http://word.mvps.org/FAQs/InterDev/C...XLFromWord.htm


Regards,
Ryan---

--
RyGuy


"Amanda" wrote:

Hi

I have a form in Word with various drop down options, check and radio boxes.
I would like to store the information into Excel. The initial form will be
emailed out to numerous people, therefore I need to be able to capture all
data, from numerous forms, into 1 excel spreadsheet?

I'm guessing I will need to be able to program, and guess what? I can't!
arrrgghh. Any help would be appreciated.

Cheers
Amanda
U.K.



All times are GMT +1. The time now is 05:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com