Visual Basic for Applications
Links to other applications exercise
Relatively easy
This Visual Basic for Applications LINKS TO OTHER APPLICATIONS exercise is provided to allow potential course delegates to assess their suitability for the Wise Owl ADVANCED VISUAL BASIC FOR APPLICATIONS course only, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.
Exercise: PowerPoint info to Excel
A full answer to this exercise is provided as part of the training course!
| 1) | Download the files needed to start this exercise: exercise-680.zip (and click here if you experience any problems unzipping this file after downloading it). | ||
| 2) | Open the PowerPoint presentation in the above folder. Feel free to press the F5 function key to run the slide show if you should so desire! Your aim is now to produce an Excel workbook containing summary slide information for this PowerPoint presentation, looking something like this: | ||
Your workbook does not have to be neatly formatted like this
|
|||
| 3) | To achieve this, first create a module withiin this presentation, and within this create a subroutine called something like ListSlideInformationInExcel. | ||
| 4) | Reference the correct Microsoft Excel object library! | ||
| 5) | Write your subroutine so that it:
|
||
|
|||
| 6) | Save your presentation with the same name, then close it down. | ||
Thank you for showing an interest in this Advanced Visual Basic for Applications training course! As mentioned above, full answers to this and other exercises are provided on the course. On all Wise Owl scheduled courses delegates can take away these model answers (together with their own efforts!) on a free USB stick.
