Save Form Data as Delimited text via VBA
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
|