Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Mar 2010
    Location
    Texas
    Posts
    49
    Thanks
    4
    Thanked 0 Times in 0 Posts
    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?

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    3,913
    Thanks
    0
    Thanked 192 Times in 176 Posts
    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
    [MS MVP - Word]

  3. #3
    WS Lounge VIP
    Join Date
    Mar 2006
    Location
    Maryland, USA
    Posts
    677
    Thanks
    17
    Thanked 57 Times in 50 Posts
    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
    Pam Caswell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •