Save Form Data as Delimited text via VBA

[Mike Henderson]

Hi

I'm trying to write some code to take some Word Forms and export them as text delimited text files. Manually I can do this, but I'd like to automate it through vba.



I can get the code to work to convert from .doc to .txt, but there is a couple of additional things I cant see how to do.

In the advanced options of word 2007 under Preserve Fidelity there is a tick box that I need to turn on for "Save form data as delimited text file". I'm struggling to find how to turn this on through vba.

Also, when the file is saved the csv file save dialog box has an option via a tick box called "Allow character substitution" at the point you choose the CSV format. I'm struggling to find this as well.

Any pointers towards documentation on these features would really be helpful if anyone can help?

Cheers

Mike

[macropod]

Is there a reason for not using the same Save method to save the form data instead of just saving the document as a text file?

With ActiveDocument
  .SaveAs2 FileName:=Split(.FullName, ".")(0) & "_Form.csv", _
    Fileformat:=wdFormatText, SaveFormsData:=True
End With

[gmayor]

You might find http://www.gmayor.com/ExtractDataFromForms.htm useful.