Results 1 to 4 of 4

Thread: Combining Word-docs based on a design in Excel

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Newbie
    Joined
    Jan 2016
    Posts
    2
    Location

    Question Combining Word-docs based on a design in Excel

    Hi there,

    I'm looking for a software or a macro to do the following. I've got around 1000 Word documents, numbered 1000, 1001, 1002, etc. Every document contains one exam question. Based on a design in Excel, I want to combine the documents, so I can get different versions (files) with exam questions.

    So the output of a version would be like:
    Version 1 contains question 1000, 1001, 1002, 1003, etc
    Version 2 contains question 1004, 1005, 1007, 1008, etc
    Version 3 contains question 1012, 1013, 1014, 1015, etc
    Version 4 contains question 1000, 1001, 1004, 1005, etc

    I would be nice if every question could get an automatic header based on their number in the version.

    Version 1:
    Question 1
    <<1000>>

    Question 2
    <<1001>>

    etc..

    Does anybody know if this is possible? You'll find the example of the Excel sheet attached.

    Thanks in advance.
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •