Hi all. I've created an interactive quiz in PowerPoint, and I'd like to be able to click a button to export the results of that quiz to a new Excel Document. The PowerPoint is set up so that on each slide, there is a question with four choices which are clickable shapes. A sample question might be "What color is the sky?" and the choices would be Blue : 1, Red: 2, Green: 3, Yellow: 4. By clicking them, it gives them points. When they click a shape, it turns from blue to red, and if they click it again, it turns from red to blue (and undoes the points). I did this by declaring "Mycount" as a public integer and then making the appropriate adjustments for when they click a shape.
Here's the most relevant bit of the code that I've got now:
I've made it so that if you click a shape named Summary, it'll open a new excel document, and enter the word "text" in A1. Here's what I'd like it to do:
1. Put the words "Total Points in cell A1 and put the "Mycount" integer in cell B1.
2. Put the word "Date" in cell A2 and the date in cell B2. I think I know how to do this already.
3. Put the question from each slide in cells A3,A4,A5, etc. and their answer to that question in cells B3,B4,B5, etc. So, cell A3 might read "What color is the sky?" and cell B3 might read "1" because "1" was the choice that corresponds with blue. For this, I was thinking the way I'd like to do it would be to name each question and each shape in the selection pane and then refer to them by name in the code if that's possible. So, for clarity, all cells in the B column will be either 1,2,3, or 4.
4. Have the file save itself as "X's Quiz Results" where X is a public string that appears elsewhere in the code.
5. Have the new excel file save itself on the desktop of the user's computer. This is a quiz that might be emailed, so when it saves, I want them to be able to see the file on their desktop so they don't have to go looking for it. I know that there are different paths to desktops, so I wasn't sure how to do it.
In addtion, I'm also having trouble figuring out how to flip back and forth between PowerPoint and Excel to do all of this. I know this is a pretty tall order, but any help on any of the parts would be greatly appreciated.
Bookmarks