process to show that it is possible to extract data from multiple Word forms and import into an? Excel spreadsheet for data analysis using? VBA.
?
The word forms is a survey and and example of the type of? data to be collected has been? designed on a word document.? The word document will be sent out via email to many users then returned to? the single host, maybe me. the word form create will be locked to? restrict data a user can enter and contain a variety of data types. I have attached a sample questionnaire that must be used or at least use the same format you would like to use? different questions.
Ultimately this is a proof of concept for future work on the real questionnaire. you will need to use at least three completed surveys? to prove it works. in future there will be hundreds of responses.
?
The file folder to collate all the word files will reside on a pc which does not have the same restrictions the respondant therefore the approach taken using VBA in the example in the following link would be ok <[login to view URL]>
The only alteration would be that I need to prove it can be done in Excel.
further detail below to follow
## Deliverables
* * *This broadcast message was sent to all bidders on Thursday Apr 2, 2009 9:04:44 AM:
Thank you for your bids to date. there are still bids coming, please bare with me. I am awaing responses from my colleauges in order to progress to a decision. Regards Cadjoseph