Importing Word Form Fields to Excel, and choosing the columns

I have seen the other posts on how to do this and I'm off to a good start I think.

I just need some help to customize this for my form. The center of the form has 6 check boxes, and I just need to include the one checked reason in column P, and then one of the 3 explanations if there is anything filled in there.

Also, for some reason with this code, when I try to import multiple files it puts them all on row 2.

Would someone mind taking a look to see if you can help.

Thanks

 

In it's current form the user can select multiple values from the set of checkboxes. Is there any particular reason why you are using checkboxes instead of option buttons that would limit the user to one selection?

Rollin

 

The form has been in use for a long time, long before I came on here. There are several hundered already saved that I need to import to Excel for reporting.

Let me back up. I edited the form to add the bookmarks to the fields thinking that would help me with the coding. But, the original form doesn't have the bookmarks so this coding won't help with the forms I already have in use.

Could you help me with code to import all of the fields and put them in the order I need?