I have a large collection of quizzes, written in Powerpoint 2007. Each quiz consists of a number of rounds, usually 10. Each round has 10 questions. So, a typical quiz presentation consists of around 150 slides, what with intros and answer slides etc.
I have created an Access 2007 database containing all the above quizzes, Fields include the date of the quiz, the organization that commissioned the quiz, the path to the Powerpoint quiz. The latter field is a hyperlink type. So, when I click on the hyperlink Powerpoint opens with the particular quiz loaded.
BUT, while that is fine and dandy, I would like to open the Powerpoint file at a specific slide number, not slide 1 which is always the default of the hyperlink.
Does anyone know how to direct the Powerpoint file to open at a specific slide? I suspect the answer is going to involve VBA, which is not a problem, but how?
Hope someone can help. I'll be eternally grateful.
Thank you
I have created an Access 2007 database containing all the above quizzes, Fields include the date of the quiz, the organization that commissioned the quiz, the path to the Powerpoint quiz. The latter field is a hyperlink type. So, when I click on the hyperlink Powerpoint opens with the particular quiz loaded.
BUT, while that is fine and dandy, I would like to open the Powerpoint file at a specific slide number, not slide 1 which is always the default of the hyperlink.
Does anyone know how to direct the Powerpoint file to open at a specific slide? I suspect the answer is going to involve VBA, which is not a problem, but how?
Hope someone can help. I'll be eternally grateful.
Thank you
Last edited: