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. Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    3,917
    Thanks
    0
    Thanked 194 Times in 177 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]

  4. #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
  •