I'm looking for a VB macro for question and answer search and population in excel and word.
This macro will search for the list of questions (whatever they are) dropped into a table in excel and the search for the same text questions and associated answers in a database set up in a .docx file.
The reason for the use of a .docx file is that some of the answers will have images and tables as part of them.
The macro will then need to open a new word document and drop each question and associated answer into it with the question listed above and the answer listed below each question.
Greetings, I am experienced with interaction between Excel and Word through VBA macros - feel free to inspect my portfolio. Finding and moving images and tables to another .docx isn't any problem. Regards