MERGING OF TWO DOCUMENTS AND SAVES AS NEW DOC BASED ON THE GIVEN CONDITIONS

  • Am having two documents having two columns in each document.

    First, document having native text and respective wrong translations and second document having native text and respective correct translation.

    Now I have to merge these two documents based on the below condition:

    Documents are .doc & .rtf fromats.

    Take first column from first document (i.e. native text column), take second column from second document (i.e. correct translation), and save as new document.

    First document name has “ -341234132_1432423-_Bilingual Doc” & “ -_Bilingual Doc ” is same for all the documents …

    Second document name has “-341234132_1432423-Bilingual-Fixed” & “-Fixed” is same for all the documents…

    Output file name and destination folder should be ask while saving the document…..

    Is it possible to automate this VBA macro, please help me in this regards.

    For more information, please find attachments.