Home > Posts > Multiple Choice generator (using VBScript / Windows Script Host [WSH])

Multiple Choice generator (using VBScript / Windows Script Host [WSH])

My tranXform free transformations software collection has been enhanced with a Multiple Choice documents generator script, dubbed MultiChoice. Copying its usage instructions here to get an idea of what it does:

It’s a script in VBScript used to generate exam documents based on multiple choice and free text questions


  1. Edit document templates at “Templates” folder. Unused test documents are prefixed with “~” char
  2. Clear output folder from old documents
  3. Navigate to Data folder
  4. Edit “OldQuestions.doc” to add any questions used in previous tests that you don’t want to reuse (copy-paste the question text – text formatting isn’t important)
  5. Edit multiple choice questions spreadsheet at “Data” folder. See existing sample there (mark unused questions with a * at the 1st column and mark correct answers with bold font)
  6. Edit Generate.vbs with Notepad
    • to select how many questions to pick from spreadsheet’s tab A, tab B and tab C
    • to select how many shuffled versions of the multiple choice document to generate [one for each student group to avoid them copying from each other])
    • to edit the length of the text that is used for spreadsheet questions to compare with old questions (from OldQuestions.doc) to see if it will be ignored
    • to select whether a filled-in with answers document will also be generated
    • to select whether comments from spreadsheet cells are shown at the generated answers document
  7. Drag-drop a questions spreadsheet (.xls file) onto the Generate.vbs script (need to have installed Windows Script Host [WSH] – it is preinstalled at recent Windows versions)

This will process all templates (apart the ones prefixed with ~) from “Templates” folder and will pick questions from the spreadsheet tabs to fill them in, ignoring any old questions. Results will be placed in “Output” folder. If you edit the script to generate a filled-in with answers document it will also generate one for each questions document generated.

Requirements: you must have WSH (Windows Scripting Host) installed. If you don’t have it, you can download WSH from Microsoft

(C)opyright 2009 – Zoomicon / George Birbilis
Free to use / give due credit


Categories: Posts Tags:
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: