Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a questionnaire that users complete. It is in Excel. After users complete the questionnaire I would like to be able to generate a Word document that contains their answers. For example "The answer to your question was [answer from Excel Questionnaire cell A49 ]"

I have seen that this is possible with Sharepoint. However, I don't have Sharepoint. I am working on MS Office 2010. I also have visual Studio Express 2010.

What is the best way to achieve the above, pretty please?

Thanks.

share|improve this question
    
If you are looking for VBA then you should be asking this at Stack Overflow – brettdj Jan 22 '12 at 0:07

Perhaps use the mail merge feature in MS Word? It wasn't originally designed for this, but you should be able to get exactly the results you need.

http://mistupid.com/technical/mailmerge/

share|improve this answer

You may be long beyond this problem, but here are links towards a solution.

This covers a range of options.

This describes only one.

Essentially, from Word 2010 use the Insert > Object button. Choose your Excel spreadsheet and then choose the range you want to select.

I am new to this process as well so I can't offer any advice about fine-tuning the formatting, but that should get you started on importing data from Excel.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .