Creating a Document to Collect Data for an Excel Workbook

[LordDragon]

Greetings,


I've been writing VBA in Excel for a while, but I have never written it for Word before.

My project / questions are simple enough.

I need to create a Word document to send to our customers so they can fill it out. We will then be "importing" that into an Excel Workbook so we can work on the details for that project.

Questions:

Do I need to create a Word Document with Macros, or can I put all the code in the Excel Workbook?

Would it be recommended to create a "Form" or a Table with Form Components?

I understand these are primarily up to my personal preference, I'm just looking for recommendations from more experienced users.

[gmayor]

The document you send out should ideally be a protected form, so that users can only fill the areas you wish to record. Where you locate the code to process the forms is less important. It can be in Outlook, Excel or Word. See http://www.gmayor.com/extract_data_from_email.htm http://www.gmayor.com/extract_email_data_addin.htm and http://www.gmayor.com/ExtractDataFromForms.htm

[LordDragon]

Graham,

Thank you, this is exactly what I was looking for. Except I'll be using Content Controls, not Legacy Form fields.