View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GhostNWN GhostNWN is offline
external usenet poster
 
Posts: 2
Default Possible to import Word forms en masse into Excel spreadsheet?

Hello,

I'm running a little questionnaire for around ~100 people and am sending
them out as Word documents. These documents are already using the Forms
option with text boxes and drop down fields.

However, I also want to analyze the data, but it would take a very long time
to import the long questionnaires one by one into Excel. Is it possible to
automate this process given that the Word document is a form?

I have already read the MS tutorial on converting Word forms into txt format
and the output is now perfect, but I suppose my second question is, would it
be possible to automate saving the doc files into txt/csv format (either into
1 big file or into individual ones)? That would let me import all those files
at once into Excel I think, right?