Append values from a MS Word form to an existing CSV or text file
I have a MS Word (Office 2016) form (attached) that uses different types of Custom Controls.
I want to extract the values and add them to an existing file, which is used as a data source for various excel spreadsheets. The existing file is located at: \\mynetworklocation\mysubfolder\sourcefile.csv
I've spent hours searching for a solution, but none seem to work. I tried exporting as a csv to a new file (with the intent of later concatenating it to the other), but the export ignores the checkbox status (true/false, checked/unchecked).
I'm at a loss.
|