Hello All;
I have created a Word form that has both legacy fields and AxtiveX fields. The form needs to use both types of fields due to how it needs to operate.
Problem 1:
I followed the export steps in Link but it doesn't cause legacy check box values to be recorded if checked. Any ActiveX radio button values that are selected also are not shown. The only values that are exported are some of the comment boxes.
Problem 2:
I haven't found a way that actually allows the ActiveX values to export correctly.
Inputs:
All legacy fields are assigned a bookmark name
All ActiveX controls are assigned a name value
Goal:
My goal is to write a macro that can export all (Legacy and ActiveX) of the values to specific cells in the excel document. If I need to export to Text / CSV, that works too since I can delimit them in Excel if absolutely needed.
Thanks in advance,
Mike
I have created a Word form that has both legacy fields and AxtiveX fields. The form needs to use both types of fields due to how it needs to operate.
Problem 1:
I followed the export steps in Link but it doesn't cause legacy check box values to be recorded if checked. Any ActiveX radio button values that are selected also are not shown. The only values that are exported are some of the comment boxes.
Problem 2:
I haven't found a way that actually allows the ActiveX values to export correctly.
Inputs:
All legacy fields are assigned a bookmark name
All ActiveX controls are assigned a name value
Goal:
My goal is to write a macro that can export all (Legacy and ActiveX) of the values to specific cells in the excel document. If I need to export to Text / CSV, that works too since I can delimit them in Excel if absolutely needed.
Thanks in advance,
Mike