Compiling Form data

Topic

New Reply

I’ve created a form template and sent it out and copies of the completed forms are rolling in. Now I have to compile all the information.

1) Can the “Save form data as delimited text file” be made persistent?

2) Is there a way to compile all the information into a spreadsheet without doing so individually?

3) I can write VBA code to do just that. Excel can import tab delimited files into columns correctly but commas in Word’s version is a problem since commas can also appear in the data. How can you export a saved Word form delimited text file into Excel?

Reply | Quote

Replies

Hi ForEachLoop,

1. AFAIK, once set, it should remain so. If not, you could use a macro to set it each time Word starts.
2. That depends on both the data and the document’s layout. For example, you may be able to create an output file just by saving the document as a delimited text file.
3. When converting to CSV, the simplest approach is to ensure the fields that could contain commas have double-quotes around them (but not within them). Excel will then handle them correctly.

Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Reply | Quote

Another option is to use tab delimited data, or pick another delimiter. You can specify the delimiter in Excel when parsing (converting text to columns in X2007/10).

Pam

Reply | Quote