"Jeopardy" in Excel and Powerpoint

[TomH]

Hi all.

I have set up a "Jeopardy"-type game show board in Powerpoint for my students. I would like to include scorekeeping as well. I have set up in Excel three cells for scores, and macros to increment those cells by different point values, applying those macros to objects so I can click to add or subtract values from their score. I currently have the powerpoint show in a window and the scorekeeping in excel in a window below.

My question is... can I somehow embed this scoring in Powerpoint? I know how to put static Excel information into Powerpoint, but can I click on macro-enabled objects within an embedded Excel spreadsheet and have that macro edit the cell value... within the Powerpoint window? I haven't been able to get this to work... and I haven't been able to find any literature that says one way or the other whether it even can be done.

Thanks for any help!!

Tom

 

[Isskint]

Not sure if this will help but i have used the attached demo to do things on the fly in Powerpoint. An article about this can be found on their website also at http://www.indezine.com although i do not have the exact page

EDIT:

Opps, just realised the file did/can not attach. Link is http://www.indezine.com/members/bank/financialprojects.zip

 

[TomH]

Thanks very much. I'll check it out.

 

[godsspeed]

I havent tried this before... but when you Insert Object--From File--(select the spreadsheet file that has your scoring)-- into a slide in powerpoint. if you double click on the object it will open the excel interface and have all excel options (formula bar and what not) while still being in/viewing the pp slide. ...if you edit this linked object, you are changing the actual file (the same as if you opened the file through excel and made the changes)

....as far as the macro part.... that i do not know. i would side with yes, but never messed with the specific circumstance.