Is it possible to only export completed form results to a new file?

[postw]

Hello all,

I have been presented with a project that involves Forms that I am not able
to resolve.

Basically I have been asked to create a document template where other team
members can fill out a form that asks a series of questions, then to have
only the completed form results export to a new file.

I am aware that Word can export the form results to a text file, but when I
do this all of the questions that were on the original form are exported to
the new file.

What we are looking to achieve in the end:
If the end user is faced with 20 questions, but only 12 of the questions
pertain to the end users project, only the 12 completed form fields will
export to a new file.

If this is not possible with Word using macros or other, can this be
completed in another application (Access / Excel / Web Form)

Thank you in advance,

Bill

 

[Jezebel]

Yes it's possible with macros, although it might be easier to do at the
receiving end. It depends on how you define 'not completed'.

 

[zkid]

This is very possible. You just need to create a macro button that the user
clicks when done filling out the form. The macro will then go through each
formfield (you should provide bookmark names for each formfield) and
determine if there is any data. If so, then import that data either to an
array to export later or just paste the data into another document. When
done, save the other document.

 

[postw via OfficeKB.com]

Thank you for the information. I will start to research more information on
using the macro button. If anyone has a good refererence point for using
macros, could you please post a link.

Thank you again!

Bill

This is very possible. You just need to create a macro button that the user
clicks when done filling out the form. The macro will then go through each
formfield (you should provide bookmark names for each formfield) and
determine if there is any data. If so, then import that data either to an
array to export later or just paste the data into another document. When
done, save the other document.

Hello all,

[quoted text clipped - 20 lines]

Bill

 

[zkid]

How to select formfields:

http://word.mvps.org/FAQs/TblsFldsFms/GotoFormField.htm

Validating contents in a form field:

http://word.mvps.org/FAQs/TblsFldsFms/ValidateFFields.htm

The VBA Help is an excellent source for information on arrays.

Hope this helps.

Thank you for the information. I will start to research more information on
using the macro button. If anyone has a good refererence point for using
macros, could you please post a link.

Thank you again!

Bill

This is very possible. You just need to create a macro button that the user
clicks when done filling out the form. The macro will then go through each
formfield (you should provide bookmark names for each formfield) and
determine if there is any data. If so, then import that data either to an
array to export later or just paste the data into another document. When
done, save the other document.

Hello all,

[quoted text clipped - 20 lines]

Bill