Questionmark's Open Assessment Platform

Microsoft Excel

It is important to note that embedding an assessment using the methods described below uses certain VBA controls. For your users to be able to see the content, you will need to ensure that they enable Macros when viewing the document.

Embedding an assessment in Excel 2007

To embed an assessment in Microsoft Excel 2007 complete the following steps:

  1. Open the Excel document where you want to add the assessment.
  2. Select the Developer tab from the Microsoft ribbon.
  3. Click the Insert Control icon and select More Controls....
  4. In the More Controls window scroll down and locate the Microsoft Web Browser control and click OK.
  5. Resize the Web Browser control to the size you want it to display and place it in your desired location.
  6. From the Developer tab on the Office ribbon click Visual Basic.
  7. Double-click on the ThisWorkbook item in VBAProject | Microsoft Excel Objects folder.
  8. Enter the following code in the Microsoft Visual Basic window:

    Private Sub Workbook_Open()
    Sheet1.WebBrowser1.Navigate "LINK TO ASSESSMENT"
    End Sub

    ...where LINK TO ASSESSMENT is replaced by the URL to call you assessment.

  9. Close the Microsoft Visual Basic window and make any final changes to your document.
  10. Click Save.
  11. From the Save as type drop-down list select Excel Macro-Enabled Document (*.xlsm).
  12. Insert a name for the document in the File name text-box and click Save.

For an example of an Excel document with an embeded assessment, please refer to the link below:

Example Excel document with embedded assessment (LINK NEEDED!)

Please note that you will need to enable Macros before the assessment will be displayed.