Powerful PowerPoint for Educators

Using Visual Basic for Application to Make PowerPoint Interactive

by David M. Marcovitz

Examples by Chapter
Chapter 10

Examples by Chapter Home | Chapter 6 | Chapter 7 | Chapter 8 | Chapter 9 | Chapter 10 | Chapter 11 | Chapter 12

Click on a an example to download it. These examples will not run over the Web, they will not run with the PowerPoint Viewer, they will not run while compressed, and they will not run with macros disabled.

# Pages from Book Description Zip Version Text Version
10 195-216 All examples from Chapter 10 Chapter10.zip
(254KB)
 
10.1 195-198 Tags - Storing the high score in the presentation using tags. Example10-01.zip
(55KB)
Example10-01.txt
(2KB)
10.2 199-202 Saving State with Tags - This modifies the quiz in Example 8.2 to allow a user to stop in the middle of a quiz and return later to the same spot. This uses tags to store information about what the user's score is and what question the user last finished. Example10-02.zip
(63KB)
Example10-02.txt
(3KB)
10.3 202-205 Writing to a Text File - This modifies the quiz in Example 8.7 not only to write the results of a quiz to a new slide but also to write the results to a text file. Note that Mac users will have to make the slight adjustment to the code by changing \ to : in the PrintablePage procedure in the line starting with Open. This change is described in the text and noted in the comments in the code. Example10-03.zip
(67KB)
Example10-03.txt
(6KB)
10.4 205-212 Reading from a Text File - This modifies Example 9.10 to allow you to read the multiple-choice questions from a text file. With this example, you could a quiz entirely by writing the questions and answers to a text file and not editing the PowerPoint file at all. When trying it out be sure that the text file questions.txt is in the same folder as the PowerPoint file. A sample questions.txt file can be found in the Zip version of this example. Note that Mac users will have to make the slight adjustment to the code noted in the comments at the beginning of the AddQuestionsFromFile procedure for this to work. Example10-04.zip
(53KB)
Example10-04.txt
(8KB)
10.5 212-215 Saving Results to Excel - This example writes the results of a simple quiz to an Excel file. Be sure to have the Results.xlsx file saved in the same folder as the PowerPoint. Note that Mac users will have to make the slight adjustment to the code by changing \ to : in the SavdToExcel procedure in the line starting with Set oWb. This change is described in the text and noted in the comments in the code. Example10-05.zip
(58KB)
Example10-05.txt
(3KB)

Examples by Chapter Home | Chapter 6 | Chapter 7 | Chapter 8 | Chapter 9 | Chapter 10 | Chapter 11 | Chapter 12


This page was created by Dr. David M. Marcovitz.
Last updated: May 14, 2012