Dear Forum
I have a question bank for my students stored in an excel sheet.
To correct spelling and grammar I export them to a word file using a form and the mail merge feature.
The form structure has no vertical fields.
question form.jpg
This merging feature converts all the excel entries to word pages using a mapping process. Finally the excel records are extracted and each row record is converted to a word page. (26 excel records 26 word pages)
Issue:
The need is to reverse the process and import the corrected questions back to my excel sheet.
Action
I found a vba macro which parses the data for a form with vertical sturture but can't use it in this case.
Do you think that it is feasible to parse the data from this mixed type form?
Bookmarks