I have a MS Word document which is a form containing 3460 checkboxes*!! I cannot dictate the format of this document - IOW, its handed to me and I have to deal with it. None of the 3460 checkboxes have a name ("bookmark" value in the properties dialog box are all empty). There is no logic in this form - for example it has a yes checkbox and a no checkbox and you can check both as an answer to one question...yeah, yeah, I know... it isnt a well thought out form, but I cannot control this....it is what it is.
I can enumerate the checkboxes using a VBA macro. But I cannot figure out how to identify the checkbox on the page, I need some way to identify the page, or anchor point or something for each checkbox, since their order may be all over the place. The only apparent identifying characteristic of a given checkbox is its visual location on the page.
So I am thinking that I need to run a macro to set the bookmark value for every checkbox fist (I cant figure out how to do this), save the document (now with named checkboxes, so at least I know which one is where) and then run a second macro to export all the data to a spreadsheet so that it can be sorted and filtered and corrected etc. Then I will need a third macro to import the corrected data back from the spreadsheet into Word.
Am I going down the wrong path here? Any other thoughts on how to attack this problem?
* the document is a Defense Security Service imposed form containing all the Risk Management Framework NIST 800-53 controls which we are required to address. The form must be completed and submitted back to DSS without changing the form, just checking the various checkboxes and filling in text areas. Its completely unmanageable in MS Word, since you can't, for example, list all the controls that are checked as "implemented".