View Single Post
 
Old 03-31-2014, 07:26 AM
rsrasc rsrasc is offline Windows 7 64bit Office 2010 64bit
Competent Performer
 
Join Date: Mar 2014
Location: Germany
Posts: 148
rsrasc is on a distinguished road
Default Need Help With Another Macro-

I have two word documents. The first one is named "Questions" and the second one is named "Answers".

I would like to have a macro so I can import the information from the second file "Answers" to the first file named "Questions".

Both documents have the same numbers of questions and answers (55--but I would like to have it for an unlimited numbers of Q&As, if needed).

Here is a sample of one question in the first document.

1. Why macros are important?
a. A macro is a collection of commands.
b. Thy can automate almost anything.
c. Macros save time and expand the capabilities of the programs you use every day.
d. All of the above are correct.

Here is sample answer in the second document:

1. (d) The requirement is to identify the reason why macros in word document are important.



What I would like to see is the following output from the macro (the question follow by the answer choice after letter "d". The wording should read "Answer: D" (capital letter)- or any letter based on the answer choice showing for the same number in the second document):

1. Why macros are important?
a. A macro is a collection of commands.
b. Thy can automate almost anything.
c. Macros save time and expand the capabilities of the programs you use every day.
d. All of the above are correct.

Answer: D

1. (d) The requirement is to identify the reason why macros in word document are important.


Any ideas or suggestions are welcome.

As always your assistance is appreciated.

Let me know if more information is required.

Cheers
Reply With Quote