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?