Excel/Word data collection

[quixote]

I'm looking for suggestions for a way to gather data from
a questionnaire that is emailed out to people. I'm not
sure if the questionnaire should be created in word or
excel. I would like to be able to electronically gather,
sort and evaluate the responses to questions. Any
suggestions on the best way and how to do this?

Thanks you,
quixote

 

[damian lee]

Excel is probaably better. If you are speaking strictly
numerical responses using the consolidate command is very
handy for collating all responses. Alternatively you can
create a macro to open a workbook extract the data and
close the data source quite easily. I have done this for
a number of smaller applications at work.

 

[Jon Peltier]

In Word, you can set the document up as a form, then save just the
replies in a save as. Automate the save as from Word or Excel, then
import it into Excel (each response document becomes a single record)
and do your stuff. Access might be better yet.

- Jon