QR Catch.

With this easy-to-use processor, you get a plain and fast way to list replies in a CSV (Comma Separated Values) spreadsheet. Most spreadsheet programs support this format.

A CSV file is only capable of holding simple one-line values like names, numbers and multi-choice selections. If that is sufficient to cover your questions, then QR Catch is the best solution for you. This is an install-and-run type of program.

No coding required.

If, on the other hand, you use multi-line text boxes or grids in a form, you will need to use a more advanced program to process the replies.

Download QR Catch | Read the help file | Reasons to use QR | How QR works technically

QR Data.

The QR Data library makes it easy to process a large number of replies, just by opening an office document or by a click of a button.

We are talking about real life office automation. This extends the functionality of your existing office programs. When using QR Forms to get replies from your users, you can insert these replies into a spreadsheet or any other office program that supports the ActiveX technology.

You need to use a script or VB code to utilize QR Data.

Before you can use QR Data, you need to install it. Since it is a library file, it cannot run by itself. An application must call it before it can do any good (Microsoft Excel, for example). Just to avoid any misunderstanding, I need to point this out...however any program or development environment that supports ActiveX can use this library.

QR Data supports all the visual objects of a QR Form.

Download QR Data | Read the help file | Reasons to use QR | How QR works technically

Collecting replies.

When designing a form, you need to decide how to get the replies back to you and how to handle them.

There are three methods to gather replies:
Attachment to an e-mail.
A file internally on the LAN.
Directly on the internet (or extranet) using FTP.

If you don't have a FTP server or don't want to use your own there are plenty free offers on the Internet. Just click on this Google search "free FTP hosting"

Processing replies.

After you have decided how you will receive the replies, you need to decide what to do with the answers.

You can choose simply to store them for manual viewing or you can bring in the heavy machinery, inserting replies into databases, spreadsheets or into any other administrative system.

The simplest way is to view a form directly from the mail and then retype the data into your records. This method is sufficient if you only have a few replies per day.

If you expect to gather numerous replies, you should consider setting up automation. There are two alternatives for the automatic processing of QR Form replies.

Both of them are free to use! See them at the top

Learn VBA.

Learn VBA in 8 steps http://www.xlpert.com/toc.htm

The Tutorial on VBA for Excel http://www.excel-vba.com/

Joseph Rubin's Excel tip http://www.exceltip.com/